Eliminate duplicates from query

[Mary M]

If you run a query against two Querys which are linked by one field. The
query returns all the records for both Querys. Example Query1 has cust # and
name ect. Query 2 has contacts, dates ect.. The only common link is between
the two Queries is cust#. If Query 2 has 3 entrys the query will return 3
records. How can you run the query to get only the last contact and not show
the others.


Query seems to work fine except that its returning multiple entrys per cust
Tried doing a find duplicates query against the Query, but it hangs never
finishes

Any help would be appreciated.

Many thanks in advance.

 

[Jeff Boyce]

Mary

I can't see your data, so I can't be sure, but...

It sounds like your one query has multiple dates per Cust#. If you change
that query, or create a new query against it, to obtain the Maximum date per
Cust#, you could then join your Query1 and that new query to see just one
matchup per customer.

Regards

Jeff Boyce
Microsoft Office/Access MVP