Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filter by Form with Union Query (2000)

    I have a form that has a Union query behind it so I can get everything from one table and everything from the other table. When I Filter by Form, the dropdown lists have Is Null and Is Not Null for the dropdown options. When I was using a query (behind the form) that didn't have the union query, it worked but it wasn't giving me the records from the other table that didn't have an outer join. Is there a way to get what a want using a Union Query? Thanks for your help.

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

    Re: Filter by Form with Union Query (2000)

    I don't think you can. It doesn't work for Totals queries either.

    (You could create a temporary table and use that as record source of the form, but that's not very attractive)

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter by Form with Union Query (2000)

    Can you use a totals query with a filter by form if you create another query using the totals query - then use that behind the form instead of the totals query.

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

    Re: Filter by Form with Union Query (2000)

    No, that doesn't make any difference, sorry.

Posting Permissions

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