Counting Field Entries

[Kasei]

Back again... I am in the process of adding some charting capability to the database I am working on. However I need to get a breakdown of one of my fields. I have a field called Status which has a drop down menu in it containing; Active, On Hold, Routing and Printing entries.

I need to get the total number of Active Jobs as well as On Hold jobs from the status field. I've tried using the Aggregate Functions to get a total for each, but I am missing something.

Your help would be greatly appreciated.