Summary of Total's for each person at Report Footer

[jamesc]

Hi Folks,

I'm having an issue with an access report that I have created. Basically my table consists of fields including "Sales Rep", "Quote No" and "Quote Amount". Each Sale's Rep will have multiple quotations along with quote amounts. I want my report to be able to produce a summary at the report footer detailing the total amount of quote's for EACH Sale's Rep. Lets say for example the table shows data as such :



James Quote no: 123 Quote amount: £1000
Kevin Quote no: 456 Quote amount: £2000
Mark Quote no: 789 Quote amount: £3000
Mark Quote no: 234 Quote amount: £4000
James Quote no: 765 Quote amount: £5000
Kevin Quote no: 877 Quote amount: £6000
James Quote no: 334 Quote amount: £7000
Kevin Quote no: 985 Quote amount: £8000
Mark Quote no: 335 Quote amount: £9000

I want my report footer to look something like this:

Total Quote amounts for James: £13,000
Total Quote amounts for Kevin: £17,000
Total Quote amounts for Mark: £16,000

Any help would be gladly appreciated, Ive been trying various things for days and just cannot find the solution.
Thanks Guys!!

James

[pbaldy]

I'd probably use a subreport based on a totals query.

[orange]

Try this query:
SELECT SalesRep,SUM(QuoteAmount) as TotalQuote
FROM YourTableName
Group by SalesRep;

Lots of info re SQL queries etc here

[jamesc]

I'm not too familiar with Sub-reporting or queries for that matter, could you show an example if possible please?
I apologise I'm a real dummy at this. My table looks as follows:

[jamesc]

is it possible to use the DSUM function for this?

[pbaldy]

Orange gave you the fish. Yes, you could use DSum(), but it would less dynamic.

[jamesc]

would this be the correct syntax for DSUM?

=DSUM("Quote Amount","trial","Sales Rep = AB") ?

I appreciate the replies guys but I'm really unfamiliar with queries , especially getting one to produce a summary at the bottom of a report.

[pbaldy]

No:

http://www.theaccessweb.com/general/gen0018.htm