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?

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

    To union query or not to union query

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

    How do I not carry over parameters from query to query?

    Guest, Sep 7, 2005, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    417
    Guest
    Sep 7, 2005
  3. Olga

    UNION or UNION ALL query question

    Olga, Apr 6, 2006, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    1,013
    Guest
    Apr 6, 2006
  4. Guest

    UNION vs UNION ALL

    Guest, Jul 31, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    750
    Michel Walsh
    Jul 31, 2006
  5. 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:
    868
    Phil Smith
    Nov 29, 2006
  6. 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:
    504
    Guest
    Jul 30, 2007
  7. Union or Union All

    , Feb 5, 2008, in forum: Microsoft Access Queries
    Replies:
    4
    Views:
    381
    KARL DEWEY
    Feb 5, 2008
  8. Union or Union All

    , Feb 5, 2008, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    479
    Marshall Barton
    Feb 5, 2008
Loading...