Results 1 to 4 of 4
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Crosstab Query - Multiple Values (A2K SR1)

    Is it possible to create a crosstab query that has more then one value?

    The attached example has two row headings, one column heading, and requires four value options. Can this be done??
    Attached Files Attached Files
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Crosstab Query - Multiple Values (A2K SR1)

    Many Thanks - I will have to check this out.... <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Regards,

    Gary
    (It's been a while!)

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

    Re: Crosstab Query - Multiple Values (A2K SR1)

    Microsoft has a KB item on multiple value fields in crosstab queries: Q209143. This also has a link to a sample database in which this has been implemented.

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Crosstab Query - Multiple Values (A2K SR1)

    ... To do this, I remembered that you can create a pivot table form that takes the data and launches excel to create the pivot table. This worked nicely. Note: Since parameter queries drive the accounting period columns, the data is first written to a table and then the pivot table is created.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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