Hi Bill, Can you do TotStand = (.TotStand + .vStand2) Bernie Lis ----- Original Message ----- From: Bill Niehaus To: RBASE-L Mailing List Sent: Monday, July 07, 2008 11:08 PM Subject: [RBASE-L] - Variable sum in a report
I have a report based upon a table (field) that I want to show a sum based upon a second table (rawdata). In the past I used a variable to lookup data from the second table. vstand2 = Stand2 in RawData WHERE trial = trial AND plotnum = plotnum Is there a way to define a variable to do a sum on a second table, or do I need to create a view and do a dbcalc on the view? Thanks. Bill
