Union Query: Data type mismatch in criteria expression

[striker73]

I am having issues with a union query of mine. I have a table that tracks certain tests. I have created two different queries (ie: one is all the tests that need a draft test sent, one is all the tests that need a final test sent), basically each query has the same exact fields.

I am trying to union these two queries together and just list the next due date (either draft or final). My query is as follows:


SELECT *, Draft as [Next Due Date] FROM qryTest_Draft

UNION

SELECT *, Final as [Next Due Date] FROM qryTest_Final


I am getting the "Data type mismatch in criteria expression" error message. I can run both queries separately and they come up just fine. Can someone help me out? Thanks!

 

[dhookom]

You don't need the "as [Next Due Date]" in the second part of the query. Do both queries have exactly the same fields and data types? Are there any criteria in the two source queries?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[lespaul]

and you may need to put DRAFT and FINAL in quotes

Leslie

 

[dhookom]

lespaul,
Good catch.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.