working with Duplicates

[Pete Rothery]

I work at an advice agency and need to ID clients who return within 6 months.
So I use a duplicate query to get the duplicates and make a report with a
subgroup on the client's name. So i have 2 opendates and 2 closeddates in
each group. I want to do the arithmatic but can see no way to select the
first or the second date as both have same fieldname.

I am thinking i might need a different approach all together??

Any suggestions really appreciated.

 

[Allen Browne]

The Find Duplicates query you created probably has a Total row in query
deign, where you GROUP BY the fields that define what a dupliate is, and
COUNT the primary key?

If so, add the date field to the query grid again.
In the Total row under this field, choose:
Min
This shows the earliest date.

Now add the date field again.
This time under the total row, choose:
Max

The query will now show the earliest and latest date from the duplicates.

 

[Pete Rothery]

Thaks Alan
That solved my problem. I should have known that - but i didn't! So thaks a
lot I will certainly check out your web site.

Pete