Jump to content

Counting Field Entries


Kasei

This topic is 6065 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

This topic is 6065 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.