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