Query with calculated fields across Multiple Tables returns duplicate values (1 Viewer)

[Kozbot]

Hello everyone

I have two tables, Production Table and Material Usage Table. I am generating reports using a parameter query (for each production run) for both of them. The material usage query contains calculated fields using fields from both tables. When I run a the query for a unique production run (there is production record per production run in the table) in Material Usage query it returns two duplicate values for one unique lot number HOWEVER with differing values in the calculated fields.

Does anyone know what is causing this and how to fix it?

Thank you!

 

[llkhoutx]

The query is bad. It would return duplicates without the calculated field.