Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Thanked 0 Times in 0 Posts

    Crosstab Query (Access 2000)

    I have a table that has data in the attached format. I need to create a crosstab query where the samples are across the top or column headings, the result is the value and where lab is the row heading. This should be easy but I don't want to group the labs field. I need the data in the following format. I have attached a stripped down comma delimited spreadsheet. Please help.

    S1 S2
    L1 Result 1 Result 1
    L1 Result 2 Result 2
    L2 Result 1
    L2 Result 2
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Crosstab Query (Access 2000)

    In a crosstab query, you MUST group on the row heading field and on the column heading field. Perhaps you can use a pivot table (I must admit that I thoroughly dislike pivot tables in Access and never use them, but they may provide what you want).

Posting Permissions

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