Duplicates in QUery

  • Thread starter Thread starter Karissa
  • Start date Start date
K

Karissa

I'm running a query comparing tickets to contracts...they're connected by
account numbers. So, one account number can have more than one contract.
Because of this, when I run the query, ticket #1234 may have 3 matches...I
want to just use the most recent contract and not even see the
others...ummm...help? I've tried doing a max on the contract date, but
that's not working.
 
Create a totals query with contract and max on the contract date. Save.
Use it in another query joined on contract and contract date.
 
Back
Top