Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    group by count in a query

    In report it is simple to create a group by count in the detail section of the report. However I need to do the same thing in a query. My query is structured as a sorted id number and a sorted test date, and a test score. I would like to create a calculated variable that would create a 1 for the first id number and the first id date, then a two for a the second test date etc. then goes back to one when a new id number changes.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Why would you want to do that in a query?

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts
    to use in a pivot formula test1 , test 2 test 3 etc, or to chart average values of test 1, test 2 test 3 etc.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    I don't think it can be done in a query. I would tend to build a temporary table and populate/massage that.

  5. The Following User Says Thank You to patt For This Useful Post:

    r3x3 (2012-09-16)

Tags for this Thread

Posting Permissions

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