Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Union Query (2003)

    I just amazed myself by creating a Union query which actually gives me the information I want, but not in the way I want. I created a query of Allocated Jobs, and a query of Completed jobs. I put these together in a Union query, and they appear on top of each other. How do I change this.

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

    Re: Union Query (2003)

    What do you want the result to be?

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Union Query (2003)

    Well preferably,

    Name Allocated Completed

    Also, can you use a Union query, within another. The query above is just for 1 week. I want to create another to compare the two weeks. I know you've helped me with <post#=581020>post 581020</post#>, but these are a different set of figures I need to work on. I need to know what percentage of the jobs allocated, have been completed. I need to compare two weeks.

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

    Re: Union Query (2003)

    A union query is not the right tool for that. If you have a query returning allocated jobs and a query returning completed jobs, you can create a third query based on those two joined on the field that identifies the job.

Posting Permissions

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