Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: Turn Query into a matrix

    Is there a simple way to use a query to create a matrix in a report. I need to gather data from 12 months and 12 different catagories. I used count functions last time but this matrix will be far larger. I used this function

    CountAug: ([Date Settled]) Between #8/1/2003# And #8/31/2003#

    and then did a dsum function to come up with the total. I hope I don't have to do 144 functions within one query. Any idea's?

  2. #2
    Join Date
    May 2004
    Posts
    6
    Could you use a crosstab query?

  3. #3
    Join Date
    Mar 2004
    Posts
    361
    I'm not sure what that is?

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    If you make a new Query there is a wizared will help you creating this CrossTable Query. Just click new under the query and choose this query type...

Posting Permissions

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