Results 1 to 4 of 4
  1. #1
    thart21 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    83

    Combine crosstab queries

    I can't get my brain wrapped around this one.
    I have a select query and 2 crosstab queries that I need to combine and export to Excel.
    The crosstab queries have the following columns
    Crosstab# 1


    Product - row heading
    Country - Column heading (creates 5 columns)
    Country Qty - Value

    Crosstab #2
    Product - Row heading
    Region - Column heading (creates 5 columns)
    Region Qty - Value

    The spreadsheet needs to have all of 10 of the columns next to each other but I can't figure out how to combine the 2.

    I can't do a Pivot table as the data is being used to populate other workbooks with VLookup (let me know if I'm wrong on this one) and will be refreshed periodically from the Access queries.

    Thanks!

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Join the 2 crosstab queries on a related field in a new query, with crosstab Q1 in columns 1 through N and crosstab Q2 in columns (N+1) through M.

  3. #3
    bgus is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    8

    Crosstab query question

    I found this thread and have a similar question.

    What if instead of appending the 2nd query columns, the person wants to have the Countries within Regions instead of appended onto the end of the first set of columns (N+1 through M).

    My problem is
    Crosstab# 1
    Shift- row heading
    Date - Column heading (creates 5 columns)
    Shift Qty - Value

    Crosstab #2
    Shift - Row heading
    Job - Column heading (creates 13 columns)
    Shift Qty - Value

    I had the idea to do a select query, filtering by date and then do a Crosstab Query like #2. But then I'd have to do a separate one for each date. In other words this is an event management database. The rows are Shifts (3 shifts per day) and the columns are 5 dates and within 5 dates there are 13 different jobs for each shift.

    (This can easily be changed to dates and jobs for rows and shifts for column)

    Thanks in advance for any suggestions on how to show this data.

    Betsy

  4. #4
    bgus is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    8
    Solved by using a single crosstab query with 1 column heading (date) and two row headings (shift and job).

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

Similar Threads

  1. Combine queries
    By thart21 in forum Queries
    Replies: 1
    Last Post: 03-05-2010, 01:39 PM
  2. Replies: 1
    Last Post: 05-28-2009, 05:08 AM
  3. Replies: 0
    Last Post: 03-31-2009, 02:05 AM
  4. Combine queries results in forms
    By frasilvio in forum Queries
    Replies: 12
    Last Post: 01-10-2008, 01:34 AM
  5. Crosstab Queries
    By albst130 in forum Queries
    Replies: 0
    Last Post: 03-07-2007, 09:32 AM

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