query with criteria promt will not carry forward after a union query

B

Brooks Friend

I created a series of queries that prompt for a date
period to be entered. When I created a union query that
combines the data (from the query that asks for criteria
and another that sums up annual data), I get an error
message "The Microsoft Jet database engine does not
recognize <name> as a valid field name or expression.
(Error 3070)". The series of queries and the report that
is based on the queries worked until I added the date
criterea prompt. Before the prompt, I identified the date
period manually. How can I fix it so the queries work
with the criteria prompt?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union query 5
SUM in a UNION query 2
How to Change criteria on a saved query using VBA 0
query to show where no data in a stated column 0
crosstab query with datea parameters 2
0uery criteria not working 1
Union Query of Two Queries (Part 2) 2
Keep name of source query in Union 2

Top