Adding the sum of a field

[Christopher Buxton]

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

 

[Duane Hookom]

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])

 

[Christopher Buxton]

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:
=Sum([Price])


--
Duane Hookom
MS Access MVP
--

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

 

[Duane Hookom]

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.

--
Duane Hookom
MS Access MVP
--

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:
=Sum([Price])


--
Duane Hookom
MS Access MVP
--

in
message news:[email protected]...

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