|
Subject:
|
Calculation in Report
|
|
Posted By:
|
lbreitenbach
|
Post Date:
|
2/9/2004 11:33:38 AM
|
Hello everyone!
I have a report that I want to have a calculation in. Let me explain what I have though so you'll understand what I want....
I have a query that is all the fields from my table + an expression that calculates the total of most of those fields. Then I have a report that I and going to have all the records showing up on, but in the page header, I want it to calculate the total of all the expression fields from the query. (Sort of a "Grand Total" of the totals.) All the records information show up in the detail portion of the report.
Any one have any ideas?
Regards,
Laura
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
|
|
Reply By:
|
jrwlkn
|
Reply Date:
|
2/9/2004 11:53:20 AM
|
you should be able to reference each of the field names in an expression. Simbply put a field in the header and use and expression to add the 'subtotal' fields together
Happy programming
John
|
|
Reply By:
|
lbreitenbach
|
Reply Date:
|
2/10/2004 7:44:27 AM
|
Worked like a charm!
I knew it was something simple...My memory just isn't all that great when I'm in a hurry!
Thanks!!!!
Regards,
Laura
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
|
