Duplicate record work-around

[Guest]

Hi. I have a query that joins two other queries. I want to create a report
using the final query. Query 1 lists sales orders. Query 2 lists production
schedules. When I join the two queries (query 3) by item and warehouse, I get
duplicate records for both sales orders and production schedules. I can
handle this by hiding duplicates in the report. But sometimes there are
multiple production schedules and multiple sales orders. In this case, I
can't seem to get around the duplicate records.
Example:
Item 12345 SO#2345 Qty 300 PO#3456 Qty 500
SO#3456 Qty 400
SO#4567 Qty 350
SO#2345 Qty 300 PO#5678 Qty 800
SO#3456 Qty 400
etc...
Any suggestions how to eliminate this duplication problem?

Thanks so much!

 

[Guest]

Hi Jennifer,

I recommend that you post this on the Queries Forum:
http://www.microsoft.com/office/com...microsoft.public.access.queries&lang=en&cr=US

Also, open your queries in SQL view, copy the text there, and post it on the
Forum.

One thing you might try if you have not already done so, is to open your
query in SQL view and add the word DISTINCT right after SELECT.

Best to you,
Hunter57
Just huntin' for some data.
http://churchmanagementsoftware.googlepages.com

 

[David Cox]

Group by