I would like to count all the records by status in group field in an Access Report.
I have the report built and a grouping set and I can count the records according to the grouping (Location)
Now I would like to do a count of the records by location and by status so I can show the following:
Oklahoma 200 / In Progress 150 / Scheduled 25 / On Hold 20 / Canceled 5
Texas 100 / In Progress 50 / Scheduled 25 / On Hold 20 / Canceled 5
I would like to count records according to P_Status where P_Status equals 'In Progress'
and I would like to count records according to P_Status where P_Status equals 'Scheduled'
some I am thinking something like the following
=count (all records) where P_Status = In Progress
and
=count (all records) where P_Status = Scheduled
...novice here so please be specific
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.