Hi -
I am trying to write a query that will give me all of the entries from one table and then add the lines from another table that have the same part number. The problem is that I cannot get the first table to show all line items even though I have a join that states to do this. Also, I know this is a problem but the table that I want to display all the line items will have duplicate part numbers. This is the way it should be. The parts table lists all the parts that should ship and the second table shows the parts that did ship. That is why there could be duplicate part numbers because possibly 4 of one item needs to ship and then I want to record the serial numbers of each item that did ship. If you could look at my sample database, you will find a part and order table and the query I have attempted is named report.
Any help is very much appreciated!
B&R
P.S. I had this in another forum and someone wrote a query (query1) but it returned duplicate line items. However, they never responded after this. Can you someone take a look at what I have. Please ask any questions!!
Thanks,
B&R
I am trying to write a query that will give me all of the entries from one table and then add the lines from another table that have the same part number. The problem is that I cannot get the first table to show all line items even though I have a join that states to do this. Also, I know this is a problem but the table that I want to display all the line items will have duplicate part numbers. This is the way it should be. The parts table lists all the parts that should ship and the second table shows the parts that did ship. That is why there could be duplicate part numbers because possibly 4 of one item needs to ship and then I want to record the serial numbers of each item that did ship. If you could look at my sample database, you will find a part and order table and the query I have attempted is named report.
Any help is very much appreciated!
B&R
P.S. I had this in another forum and someone wrote a query (query1) but it returned duplicate line items. However, they never responded after this. Can you someone take a look at what I have. Please ask any questions!!
Thanks,
B&R
