Jump to content

Doing a Count on a subset of records


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

Recommended Posts

  • Newbies

I'm trying to figure out how to do a "Count" on a subset of records. I can do a search to find the records I need and do a count of the number of records found, but I also need a "count" on a subset of records.

For example:
I can do a FIND to list all of the widgets (1record per widget) I've sold in the month of November and do a COUNT of the number of  records to total the number sold. I also need to count the number of Red, Blue, and Green widgets within that same list.

i.e.  November: 30 widgets sold;  12 Blue,  10 Red,  8 Green

Link to comment
Share on other sites

  • Newbies

Ahh.. I see how that would work, thank you. Unfortunately I need to maintain the sort order, in my case, alphabetical order of the name not the color.

Edited by MCT
Link to comment
Share on other sites

This topic is 3017 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.