Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Union Query (Access2000-03)

    I am using Union Query for the SUB Report.
    Because of my form contains combo box where I am picking ID to run report for I need to add criteria to the query like
    [Form]![Frm.Name].[cmb.Name] etc.
    How can I do it with a Union query?
    Is there way?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Union Query (Access2000-03)

    Create a *new* query based on the union query and add the criteria to this new query.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Union Query (Access2000-03)

    I was hoping table...I will try. Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Union Query (Access2000-03)

    > I was hoping table

    What do you mean by that?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •