My query Sum on report footer.

[Fred's]

Hi folks,

I have a report based on a query. Now, I 've just discovered that I
forgot to sum the total units received
and to put that sum on my report footer.

To do that, I 've create a new query. Now I will like to have a text
box, or something like this that will
pull the quanity from my query and to show that quantity on my report?

How canI do this?

Thanking you all for your help!

Fred's

 

[Wayne-I-M]

Hi

Normally you don't need to have an extra query. If the details are on the
report you can create the sum text box in the footer and run the calculation
at the time the report is opened or printed.

If you give more details of the calculation you are looking for someone will
be able to assist