Results 1 to 3 of 3
  1. #1
    tazzmann67 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    3

    Count of field based on specific values

    I have a table that includes a field called ABC_Rank. this field returns the values of A, B, C, or N. these are how we have our companies customer rankings setup. i need to know how to get a total for each. this report is by sales rep so i will need an individualized total for each rep as well as an ending report total for all reps w/ a,b,c,n ranking

    In other words the result from what i have pasted below would be:
    A - 1
    B - 2
    C - 1
    N - 5



    OffDayDeliveriesLocationTypeCustomer_NameRouteSequence_NumPtyDelivery_DaysTotal_PiecesCubeWeightTotal_CostService_TimeOpen_CloseSales_NumSales_NameABC_Rank0000058035SITFRESHENS LAREDO MALL291S30W26327289200:20:107:00 / 18:00
    * * * * *N0000059809SITEL VAQUERO MEXICAN REST102S65
    16134732400:00:000:00 / 0:00
    * * * * *N0000138809SITCITY OF CORPUS SENIOR SRV330N180TR20188902500:16:537:00 / 18:00153ROCKY MYERSA0000103861SITCHINA INN(H)301S60T9132742700:10:5410:00 / 21:00153ROCKY MYERSC0000043577SITHEADSTART DOWLING301S95M28215071100:00:000:00 / 0:00153ROCKY MYERSB0000025083SITSCORES431S90MF23185542600:18:327:00 / 18:00153ROCKY MYERSB0000058391SITPIRATES ISLAND SEAFOOD HOUSE535S130MR33278595300:18:228:00 / 14:00153ROCKY MYERSN0000058391SITPIRATES ISLAND SEAFOOD HOUSE630S270MR211532910000:13:528:00 / 14:00153ROCKY MYERSN0000058391SITPIRATES ISLAND SEAFOOD HOUSE233S170MR95882,56110100:41:378:00 / 14:00153ROCKY MYERSN

  2. #2
    tazzmann67 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    3
    sorry. that table view i had pasted somehow got messed up when it posted.

  3. #3
    tazzmann67 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    3
    ABC_Rank
    N
    N
    A
    C
    B
    B
    N
    N
    N

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

Similar Threads

  1. Replies: 4
    Last Post: 04-20-2013, 10:12 AM
  2. Count Field Values.
    By Cined in forum Access
    Replies: 3
    Last Post: 03-03-2011, 03:21 AM
  3. Replies: 1
    Last Post: 03-27-2010, 06:13 AM
  4. Count of Unique Values
    By vsmk in forum Queries
    Replies: 2
    Last Post: 03-14-2010, 12:07 AM
  5. Replies: 1
    Last Post: 11-10-2009, 03:20 PM

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