Rookie Question: (1 Viewer)

Ok Ive completed my inputing and recalling data features, now its time for me to hit the reports, it seems I need a little direction is someone could give me some

All I need to know is at what level do I SUM currency data if I need to display the total amount of all records of payment.

For instance,

I created a report based on a query (Payment Info, Invoice, Client Info) On the report I want to sum 1 field (Payment_Amount) in the footer of the report. I cant seem to get it to add up.

Am I missing a calculated field? Do I need to edit my query?

This report will accept a credit card number, then generate all the invoice/Client information based on the credit card number. This part works, I am able to display the 10 or so records with their payment amounts, I need to sum the payment amounts now but am not sure how to proceed. Any tips? Can someone tell me what to search on?

Thanks
Jordan

Answer for the rookie:

You need to do some more reading, you were putting the info in the page footer section and not the report footer section!

WTG Brainiac!


Yes I answered my own question but I read up on some old posts

heheh