Duplicate Query Question

[danbl]

I have large DB and I want to now look at duplicates. I used the Query Wizard to create a duplicate query. When I view the data without a date range I can see the duplicates by sorting the records. However when I add a date range to focus on specific periods of time I get no duplicate results??? The date range is specified by between [start] and [finish].
Can someone tell me what I am doing wrong???

Thanks

 

[The_Doc_Man]

If you have no duplicates in the selected range, you would get no duplicates in the range-filtered query.

There is also the issue of whether you picked the right format for selecting the range.

Finally, there is such a thing as query layering. If you have a named/stored query to do the Dups check, use that query rather than the base table as the data source for the time range filtration.

 

[danbl]

I have tried the query and get the same result ..... it is when I attempt to add the date range that I get no results.

 

[plog]

Can you provide a sample of your database to demonstrate this issue?

 

[danbl]

Surprise .... for me anyway ..... it was an issue of how the date parameter was entered.

Thanks to all of you

 

[The_Doc_Man]

Yep - date strings and dates are not the same thing.