Union Query Removing records

[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.

 

[KARL DEWEY]

Try modifying the union like this ---
UNION ALL SELECT .....

 

[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.

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.

 

[Jeff Boyce]

Emma

If the earlier responses have not identified your solution, please post the
SQL statement that your query uses.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Emma Aumack]

That was it. Thank you!