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

    Union Query (2003)

    I have a Union Query that I am trying to create a report with. The Union query is rather complex. When I run the query, it takes about 2 or 3 minutes to create. When I try to use the Union query to create a report, it is like molasses. When I try to put the fields on the report it is very slow. Is there something I can do to make this faster? If not, I will just go with the query.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Union Query (2003)

    Hans,

    Are you confusing a crosstab query with a union query?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Union Query (2003)

    Yes, I'm not thinking clearly, sorry. I'll edit my reply.

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

    Re: Union Query (2003)

    Original reply deleted by HansV because it made no sense whatsoever - thanks to Mark Liquorman for showing me the error of my ways.

    It might be best to create a make-table query based on the union query and run that when necessary. Base the report on the resulting table instead of on the union query.

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Union Query (2003)

    I do it all the time. We read so many of these posts, that we sort of pick-out the significant facts (such as "poor query performance"), then interpret (or misinterpret) what we read based on what we expected! I figure such an occasional slip-up is allowed, especially when you get to the age you can blame it on "a senior moment".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Union Query (2003)

    Yep, I'm getting to that age... <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20>

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Union Query (2003)

    >>Yep, I'm getting to that age... <<

    I believe I'm already there! And it ain't pretty. This is not how it was supposed to be; everything they told us growing up in the 50's and 60's turned out to be a lie!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Union Query (2003)

    Yes, but my father is 85 going om to 86, I'm sure he didn't expect the way he is now either...

  9. #9
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Union Query (2003)

    My father turns 87 in Sept, which brings me to my next big problem. What do I get him for his birthday!

    But our fathers were probably the last generation that worked for a single company most of their adult lives and then retired when they wanted to. My retirement plan depends largely on hitting the lottery one day!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Union Query (2003)

    A birthday present for my father isn't difficult - he still likes good wine, and he likes to listen to music, so a bottle of wine and/or a CD is always welcome.

    But we're drifting very far off the topic... <img src=/S/jollyroger.gif border=0 alt=jollyroger width=29 height=18>

Posting Permissions

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