Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Oakland, CA
    Posts
    126

    Lightbulb Unanswered: Simple, count diferrent values from one field on one report

    This seems like a simple problem, I've spent last hour to figure it out and ended up with count(*). I have a simple db that monitors missed days at work. One field is called [Reason for Absence]. That field can store vacation, illness, etc. Now let's say I want to count all the vacations, all the holidays, and all the illnesses on one report. I do not want to build additional queries. What can I do?

  2. #2
    Join Date
    May 2002
    Location
    Atlanta, GA
    Posts
    117
    Try grouping by the field [Reason for Absence] and then creating a field with the control source set to =Count(*).

    Kal

Posting Permissions

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