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

Discussion in 'Microsoft Access Queries' started by Brooks Friend, Jul 31, 2003.

  1. 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?
     
    Brooks Friend, Jul 31, 2003
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    To union query or not to union query

    Guest, Feb 3, 2005, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    345
    Guest
    Feb 4, 2005
  2. Olga

    UNION or UNION ALL query question

    Olga, Apr 6, 2006, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    412
    Guest
    Apr 6, 2006
  3. Guest

    UNION vs UNION ALL

    Guest, Jul 31, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    427
    Michel Walsh
    Jul 31, 2006
  4. Phil Smith

    A union B works, A union B union C fails

    Phil Smith, Nov 28, 2006, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    523
    Phil Smith
    Nov 29, 2006
  5. kev100 via AccessMonster.com

    Can 2 Union Queries Be used in Another UNION ??

    kev100 via AccessMonster.com, Jul 30, 2007, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    238
    Guest
    Jul 30, 2007
Loading...

Share This Page