PC Review

Thread Tools Rate Thread

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

Brooks Friend
Posts: n/a
      31st Jul 2003
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?
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
A union B works, A union B union C fails Phil Smith Microsoft Access Queries 2 29th Nov 2006 06:50 PM
UNION or UNION ALL query question Olga Microsoft Access Queries 2 6th Apr 2006 08:49 PM
To union query or not to union query =?Utf-8?B?U2V0aCBTY2h3YXJt?= Microsoft Access Queries 2 4th Feb 2005 11:29 PM
auto-fill, set carry to, set carry on etc vw Microsoft Access Forms 1 4th Sep 2004 07:29 AM
Inserting subdocument in master does not carry forward document properties Sandeep Sharma Microsoft Word Document Management 1 9th Feb 2004 07:32 PM




All times are GMT +1. The time now is 07:15 PM.