Question Locked

Union three or more select queries

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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];

1 reply

This discussion is closed to new replies.