Hello there.
I have a UNION query called qry_qtypersheet_check with two fields [Part_No] and [Qty_per_Sheet], it pulls data from 3 different quaries and show records WHERE Qty_per_Sheet IS NULL.
For database to process information properly, every Part_No needs to have Qty_per_Sheet assigned...