Union Query Removing records

E

Emma Aumack

Does anyone know why a union query would remove records?

I have three data tables that I combine to get total sales and for some
reason when I use the union query records go missing.
 
J

John W. Vinson

Does anyone know why a union query would remove records?

I have three data tables that I combine to get total sales and for some
reason when I use the union query records go missing.
Click to expand...

Records that are duplicates (in the fields selected in the queries) will
indeed be removed. UNION ALL instead of UNION causes all records to be
retrieved, duplicates or not.
 
Top