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!