Adding the sum of a field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christopher Buxton - 31 Oct 2005 01:51 GMT

My report prints a receipt with all the customers details in the page header.
The products purchased are in the details section of the report. The fields
used for each product are 'product number', 'description' and 'price'.

In the page footer I would like to display the sum of the 'price' field,
this is the total price for all purchases. What is the best way to do this?

Thanks

Reply to this Message

Duane Hookom - 31 Oct 2005 03:50 GMT

The best way is to use a group or report footer for the sums. Use a text box
with a control source of:
=Sum([Price])

Signature

Duane Hookom
MS Access MVP
--

> My report prints a receipt with all the customers details in the page
> header.
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Christopher Buxton - 31 Oct 2005 16:50 GMT

this does not work. should it still work even though the field is in currency
format.

thanks

> The best way is to use a group or report footer for the sums. Use a text box
> with a control source of:
[quoted text clipped - 11 lines]
> >
> > Thanks

Reply to this Message

Duane Hookom - 31 Oct 2005 18:29 GMT

A field from a report's record source should not normally have any
formatting applied. The formatting might convert a numeric or currency or
date field to text which is not very functional.

Next time, when you state "this does not work", please tell us why. It's a
bit difficult to see your computer screen from our locations.

Signature

Duane Hookom
MS Access MVP
--

> this does not work. should it still work even though the field is in
> currency
[quoted text clipped - 19 lines]
>> >
>> > Thanks

Reply to this Message