Results 1 to 2 of 2
  1. #1
    AlexR is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2016
    Posts
    1

    Query Totaling Help

    Hello,



    I have 2 fields, 1 is a list of students names (field1), the other is the corresponding students class code (field2). Field 2 has data "R1-R7, B1-B7, A1-A7, M1-M7" I want to know how many students there is in each lettered group (A, M, B, R). I've used the 'count' total query however that only gives me the number of students in each individual class e.g. R1, B6, M3. I need a way to count the total of all the students in the 'R' group (R1-R7) and so on for the other 3.


    Thanks,
    Alex

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    create a new column in in your group by query called say classgroup, then the calculation would be left(classcode,1) and group by it - also remove your existing classcode column from the query

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-10-2015, 01:58 PM
  2. Query/Report Record Grouping/Totaling
    By mikej2505 in forum Access
    Replies: 1
    Last Post: 10-04-2014, 10:29 AM
  3. Sub totaling in a query or report
    By n2mee in forum Queries
    Replies: 8
    Last Post: 11-16-2013, 03:55 PM
  4. Replies: 3
    Last Post: 01-29-2013, 08:59 AM
  5. Running totaling with a query
    By tttccc in forum Queries
    Replies: 1
    Last Post: 03-28-2012, 09:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums