Query out Duplicate Values...

J

Josie.C

Hello,

Is there a 'better' way to filter out duplicate records
in a query? (as compared to MSKB article 209183). Im
currently quering our MRP system for open orders, the
anomaly is that one customer may have two open orders but
one job issued to fulfill it.. thus in the queired time
period two jobs will show.... Unforutnatley i cant
change anything on the MRP system!

Any suggestions would be welcome...

Josie.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Delete Query? 0
Duplicates Query not showing correct results 1
How To Run a SQL Query to Create a New Column 1
Date() Problem in Query 2
Filter out values of £0.00 in a query 3
Making a query to get data from a parent-child table 1
Creating a multi-step custom macro-Access 2007... 0
Nested queries... 0

Top