Question
June 26, 2007 at 05:11 AM
amrockwell2

Union three or more select queries

by amrockwell2 . Updated 19 years, 4 months ago

I have created a union query in Access, but I receive an error: The Microsoft Office Access database engine could not find the object “. Make sure the object exists and that you spell its name and path’s name correctly. When I use a combination of any two of these three selects, the union works, so I assume the problem lies in the third union all statement. Thanks for your help.

SELECT Received
FROM Records
WHERE MONTH(Received)=[Enter Month] AND YEAR(Received)=[Enter Year]
UNION ALL
SELECT Issued
FROM Records
WHERE MONTH(Issued)=[Enter Month] AND YEAR(Issued)=[Enter Year];
UNION ALL
SELECT Sent
FROM Records
WHERE MONTH(Sent)=[Enter Month] AND YEAR(Sent)=[Enter Year];

This discussion is locked

All Comments