Results 1 to 5 of 5
  1. #1
    jortizz is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    8

    Question Query to combine multiple queries

    I have 3 queries with sales information. Their format is as follows:

    Query 1:
    [Item #] [Acct Name] [Week #] [2011 Sales $]
    542..............ABC........Jan Wk 1....$9,000
    625............. XYZ....... Feb Wk 2.... $350

    Query 2:
    [Item #] [Acct Name] [Week #] [2010 Sales $]
    625............ XYZ........Feb Wk 2.... $200


    725............ DEF........ Jan Wk 3.... $528

    Query 3:
    [Item #] [Acct Name] [Week #] [2009 Sales $]
    542............GHI.........Jan Wk 4.......$112
    625............ XYZ........Feb Wk 2.......$775



    I would like to join them into 1 query that looks something like this. Every query I have tried usually duplicates data and I'm not sure why. Note that new columns have been added:

    New Query:
    [Item #] [Acct Name] [Week #] [2011 $] [2010 $] [2009 $]
    542.............ABC.......Jan Wk 1...$9,000.......0........$112
    625.............XYZ.......Feb Wk 2...$350......$200.......$775
    725.............DEF.......Jan Wk 3......0.........$528........0

    I'm not an Access expert so any help with details is appreciated. Thank you.

  2. #2
    alansidman's Avatar
    alansidman is offline Life @ 7100'
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,456
    What does your table look like. I think that this can be accomplished with a cross tab query if all the information is in one table. Look at this video for a tutorial.

    http://www.datapigtechnologies.com/f.../crosstab.html

    Alan

  3. #3
    jortizz is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    8
    Alan, I have gotten this to work with the crosstab query you suggested. Thank you so much. However, your link does not work for me. I would like to see this video. Do you have another link?

  4. #4
    alansidman's Avatar
    alansidman is offline Life @ 7100'
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,456
    Try this and then scroll to the appropriate tutorial

    http://www.datapigtechnologies.com/AccessMain.htm

    Alan

  5. #5
    jortizz is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    8
    Quote Originally Posted by alansidman View Post
    Try this and then scroll to the appropriate tutorial

    http://www.datapigtechnologies.com/AccessMain.htm

    Alan
    Thanks Alan -This video gave me some new ideas that I will be trying.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can we combine 3 queries on 1 report? :?
    By radicrains in forum Queries
    Replies: 3
    Last Post: 10-28-2010, 09:35 PM
  2. Combine Queries
    By Steven.Allman in forum Queries
    Replies: 9
    Last Post: 08-30-2010, 12:13 PM
  3. Combine 3 Queries
    By Logix in forum Queries
    Replies: 1
    Last Post: 06-10-2010, 06:03 PM
  4. Combine crosstab queries
    By thart21 in forum Queries
    Replies: 3
    Last Post: 05-03-2010, 10:36 AM
  5. Combine queries
    By thart21 in forum Queries
    Replies: 1
    Last Post: 03-05-2010, 01:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums