summarizing drop down results

[AccessForumUser]

I'm using lookup values to view totals from my table in my Detail pane of my report. I'm using a date range criteria in my query as well as 2 expressions to convert 2 check boxes to decimal values.



the problem i have is that when the same lookup name comes up in my report results, it is shown however many times there is a record with that name in it, so it's basically showing a summary on each record instead of the total number for the person.

if I use the Totals button, and put my values in below the report footer, i get the numbers, but they are all compounded together from all the names.

my question is, is it possible to organize the totals under each name instead of repeating the same name over and over with that total?

See below to understand if this doesn't make 100% sense..:
Right now I see this:

Roger
bought # of cars - 2

Sue
bought # of cars - 6

Roger
bought # of cars - 3

Tara
bought # of cars - 4

Sue
bought # of cars - 1

What I would like to see is this:
Roger
bought # of cars - 5

Sue
bought # of cars - 7

etc..

Any help would be appreciated... Thanks!

[ranman256]

you need some queries, the base query, qsBaseRng , the data in a date range, select * from table between date1 and date2

1 qry , qsCountOfCarsBought, based on qsBaseRng, select Count(car) from qsBaseRng

1 qry, qsCarsByPerson, : select person,Count(Cars) from qsBaseRng

1 qry to analyze both, bring in both qrys ABOVE, qsCountOfCarsBought and qsCarsByPerson
to get your PERSON ,[COUNTofCARS]-[COUNTofPERSONCARS]