Adding the sum of a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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])
 
this does not work. should it still work even though the field is in currency
format.


thanks

Duane Hookom said:
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
--

Christopher Buxton said:
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
Click to expand...
Click to expand...
 
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
--

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


thanks

Duane Hookom said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top