Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    15

    Unanswered: Crosstab Query...

    Hi All!

    Belated Happy New Year!

    I want to create a crosstab query based on one table with the following fields: Status, Buyer, Site, Requisitions. The values are the total count of Requisitions for eac site per Status. I want my crosstab to appear like this...

    BUYER 1 BUYER 2
    STATUS SITE 1 SITE 2 SITE 3 SITE 1 SITE 2 SITE 3
    RAISED 1 4 3 1 4 3
    APPROVED 3 1 2 3 1 2
    TRANSFERRED 0 3 1 0 3 1
    RECEIVED 2 1 5 2 1 5

    Can this be done in Access?

    Hoping for your quick reply.

  2. #2
    Join Date
    Sep 2009
    Posts
    15
    Oooopss sorry not formatted. I've attached a sample detail and the summary i want to produce
    Attached Thumbnails Attached Thumbnails CROSSTAB.jpg  

Posting Permissions

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