Simple Report Problem

moagli

Registered User.
Local time
Today, 08:37
Joined
Nov 17, 2006
Messages
15
I have a report that is an invoice, so in the header section is the company logo, and then below that is the Nameheader because the report is sorted by name and the customers address is here. In the detail section is all the stock that customer has bought and so contains a list of information, how at the bottom of that list do i enter the total price?? if you need any more information just ask!!??

Thanks in advance
 
moagli said:
I have a report that is an invoice, so in the header section is the company logo, and then below that is the Nameheader because the report is sorted by name and the customers address is here. In the detail section is all the stock that customer has bought and so contains a list of information, how at the bottom of that list do i enter the total price?? if you need any more information just ask!!??

Thanks in advance

Place a text box from the toolbox into the report where you want the total to be.
If the name you are using for the individual cost of each item is "item_cost" (for example) you would enter into the text box:
=Sum([item_cost])

This should give you the total for all the items on the report.

Or you could do the same calculation in the query that is creating the report.
 

Users who are viewing this thread

Back
Top Bottom