How can I determine distinct records in an Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003 and I have just performed an 'append query' to have
data from two tables consolidated into one. The trouble I have is that the
field I used as a link can often appear twice in the second table and
therefore pulls back two or more records. The two or more records aren't
identical however, they will usually have at least one field that is
different.

For example, if I have CustomerA who has two orders, both orders are
retrieved into the append table however I only want to see the latest order
placed not the earlier orders. What is the best way of only having the latest
match appear?

Many Thanks
Renee
 
use an aggregate query to get the max date for each, then
join back to the table to select only the records with the
max date

(david)
 
Back
Top