Total of Totals

  • Thread starter Thread starter NeoPuma
  • Start date Start date
N

NeoPuma

Hey there,
I've set up a database consisting of four tables. I run a query which
calculates a total for the item (unit price * quantity). Is it
possible to calculate the final total of all this for a report?

If that's possible, how can I get it to be at the bottom of all the
records but only on the last page?

Thanks
Mathew
 
Yes.
Open the form in design view, click on menu VIEW - Report Header/Footer and
add a text box in the footer with Control Source =[unit price] *
[quantity] and set the Running Sum property to Yes.
 
Yes.
Open the form in design view, click on menu VIEW - Report Header/Footer and
add a text box in the footer with Control Source =[unit price] *
[quantity] and set the Running Sum property to Yes.
--
KARL DEWEY
Build a little - Test a little

NeoPuma said:
Hey there,
I've set up a database consisting of four tables. I run a query which
calculates a total for the item (unit price * quantity). Is it
possible to calculate the final total of all this for a report?
Click to expand...
If that's possible, how can I get it to be at the bottom of all the
records but only on the last page?
Click to expand...
Thanks
Mathew
Click to expand...
Click to expand...

Hi Karl,
Thanks for your reply.
I've already got a field in the query calculating the total cost for
each item, I just want to add them up.

http://neopian.co.uk/access-error.jpg
In this picture, where the blue arrow points is where I would like the
overall total (at the bottom of it all, so only on the last page).

And the there is no 'yes' value, so I set it to 'Over Group' and 'Over
All', and both returned £200.

Hope that makes things a bit more clearer.

Thanks
Mathew
 
Use the report footer and add a control to it.

In the footer add a control with a formula that looks like the following
as the control;s source

=Sum([Unit Price] * [Quantity])



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Yes.
Open the form in design view, click on menu VIEW - Report Header/Footer and
add a text box in the footer with Control Source =[unit price] *
[quantity] and set the Running Sum property to Yes.
--
KARL DEWEY
Build a little - Test a little

NeoPuma said:
Hey there,
I've set up a database consisting of four tables. I run a query which
calculates a total for the item (unit price * quantity). Is it
possible to calculate the final total of all this for a report?
If that's possible, how can I get it to be at the bottom of all the
records but only on the last page?
Thanks
Mathew
Click to expand...
Click to expand...

Hi Karl,
Thanks for your reply.
I've already got a field in the query calculating the total cost for
each item, I just want to add them up.

http://neopian.co.uk/access-error.jpg
In this picture, where the blue arrow points is where I would like the
overall total (at the bottom of it all, so only on the last page).

And the there is no 'yes' value, so I set it to 'Over Group' and 'Over
All', and both returned £200.

Hope that makes things a bit more clearer.

Thanks
Mathew
Click to expand...
 
Use the report footer and add a control to it.

In the footer add a control with a formula that looks like the following
as the control;s source

=Sum([Unit Price] * [Quantity])

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
Yes.
Open the form in design view, click on menu VIEW - Report Header/Footer and
add a text box in the footer with Control Source =[unit price] *
[quantity] and set the Running Sum property to Yes.
--
KARL DEWEY
Build a little - Test a little
:
Hey there,
I've set up a database consisting of four tables. I run a query which
calculates a total for the item (unit price * quantity). Is it
possible to calculate the final total of all this for a report?
If that's possible, how can I get it to be at the bottom of all the
records but only on the last page?
Thanks
Mathew
Click to expand...
Click to expand...
Hi Karl,
Thanks for your reply.
I've already got a field in the query calculating the total cost for
each item, I just want to add them up.
Click to expand...
http://neopian.co.uk/access-error.jpg
In this picture, where the blue arrow points is where I would like the
overall total (at the bottom of it all, so only on the last page).
Click to expand...
And the there is no 'yes' value, so I set it to 'Over Group' and 'Over
All', and both returned £200.
Click to expand...
Hope that makes things a bit more clearer.
Click to expand...
Thanks
Mathew
Click to expand...
Click to expand...

Thanks! Works =D
 
Back
Top