G
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!
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!