My query Sum on report footer.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred's - 22 Jan 2008 23:00 GMT

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

Reply to this Message

Wayne-I-M - 23 Jan 2008 08:34 GMT

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

Signature

Wayne
Manchester, England.

> Hi folks,
>
[quoted text clipped - 11 lines]
>
> Fred's

Reply to this Message