Show total of amount in report (1 Viewer)

Jaydee-187

Registered User.
Local time
Today, 08:37
Joined
Apr 23, 2017
Messages
9
Hi,

From my db frmWhatDates, I can give a parameter of the dates for a report but it shows all the days for that period with each amount.

Is there a way to show the total or sum rather than each amount.

Thanks
 

Attachments

  • Capture.JPG
    Capture.JPG
    80.8 KB · Views: 83
Last edited:

June7

AWF VIP
Local time
Today, 00:37
Joined
Mar 9, 2014
Messages
5,423
Can have a textbox in report header or footer section with expression: =Sum([QuantityOfFood]). Can also show a subtotal in each group header or footer section with another textbox and the same expression.

And if you don't want to show the detail records, set Detail section as not visible.
 

Users who are viewing this thread

Top Bottom