Trying to group records but different dates don't allow grouping

[jallen919]

I have four columns on information: Name, Sales Item, #of Items Sold Per Day, Date of Sale.

I want to create a report (which I assume I should base on this query) that shows Sales Items, # of Sales Items Sold (based on date range) for specific Name.

I have created a query that prompts for the date range but the problem is that when I run the report, if the same Sales Item and Same person sold on two different dates I have two entries on the report. I don't really care when the person sold the item, I just need a total number for each name and each item... can anyone please help?

 

[MichaelRed]

Create the report's recordsource in two steps. First, just get all fields using the date range. Then do a second grouped by sales person name.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over