Newbie: Adding records up in reports 1

[Stevehewitt]

Hey everyone,

I have a report that lists a certian customers (varies, uses a parameter query) purchase history record by record. It states on each transaction (record) what our Gross Profit is.
My problem is that I need to have a total of our gross profit on the footer of the report. As we all know, in design view you can just see the one field so I am stuck as how I can do this.

Any ideas?

Thanks in advance, Steve Hewitt
Systems Manager

 

[Trendsetter]

Use the field that shows the Gross Profit and copy to paste into the Report Footer - once there change the control to have Sum in front so if...
Source = [SalesPrice] - [Expenses]
then
Source = Sum([SalesPrice] - [Expenses])

 

[Stevehewitt]

Hey

I'm not sure I follow you! So I have my Gross Profit box in the design view still stating:

=[Sales Value] - [Costs]

but I have a new text box with a control source of

Source = Sum([SalesPrice] - [Expenses])

And that will state the total value of all records on that report? So if I have three records which are all at £2000 GP each this new box with the SUM in it will tell me that theres £6000 total GP? Sorry, Like I said in the title, I'm a newbie to Access/SQL!!!

I'll try it shortly.

Cheers, Steve Hewitt
Systems Manager

 

[Trendsetter]

If you send me an email to frank@fhsservices.co.uk with header "Sum in Footer" I have made a small demo for you