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