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!

__________________
Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

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

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!