Query Problem Please Help!

[Jkittle]

I have issues with a query for my production numbers. I can not modify anything in the tables sense they were developed years ago before me and contain thousands of records.

The two tables I need information from have a common field "Shift Code". One table contained records from the machine on pieces packed by shift code/press and the other contains down time by shift code/press. However if there is no down time the press ID is not recording in the down time table.

I have been able to run two separate query to get the information I need but would like to have one to get both and be able to then add in my machine productivity numbers. When I try to join the two tables it either double or triples my records or I don't get information because there is nothing recorded in the downtime table. Sorry this is long winded. I have attached my DB for review.

 

[Jkittle]

Query/Table Join Issue

Anyone have any ideas why I can’t join query Q-Down Time Query Query and Q-PCS Packed Query and get what I'm looking for?

Q-PCS Packed Query gives me the pieces packed by press and shift code and Q-Down Time Query Query give me the down time by press shift code.

I just can't find a way to join the two tables or query to get them on the same query.

 

[antoka05]

See attached file in wich I inserted queries [NEW Query1] and, if PRESS and PressID are not compatible, [NEW Query2].

Regards,
Antonio

 

[Jkittle]

Antonio,

Thank you very much. I see what the issue is now.