Duplicate Search Query filtered by Date Range

[jtm013]

Hello All,



I have searched so far come up with nothing helpful.
I have a query that is barebones made using the Query Wizard. All it does is count the duplicate values and display them.
I just need to add the ability to run the query only on records between a certain date range.
Right now In design view my query looks like this.

Field:	Customer Name Field: Customer Name	NumberofDups: Customer Name	Customer Name
Table:	Tbl_Data_entry	Tbl_Data_entry	Tbl_Data_entry
Total:	First	Count	Group By
Sort:		Ascending
Show	Check	Check
Criteria:		>1
Or:

This returns something along the lines of

Mr. Red- 34
Mr. Blue- 13
Mr. Green- 12
Assuming that is the number of times red, blue, and green show up in the whole database. I need to be able to only query a certain date range.

I tried:

Field	Customer Name Field: Customer Name	Numberofdups:Customer Name	Customer Name	Date Initiated
Table	tbl_data_entry	tbl_data_entry	tbl_data_entry	tbl_data_entry
Total	First	Count	Group By	Group By
Sort		Ascending
Show	Check	Check
Criteria		>1
Or

However, this just returns

Mr. Red-2
Mr. Red-12
Mr. Red-20
Mr. Blue- 2
Mr. Blue-5
Mr. Blue 6
etc.

I presume this is because while it is only querying the supplied date range it is also grouping duplicates by dates. I don't want it to do that.

Any help is appreciated thank you!

JT

[June7]

Don't Group By on the [Date Initiated] field. Select WHERE and Criteria parameters:

BETWEEN [enter start date] AND [enter end date]

[jtm013]

Thanks! That did the trick!!!