Count specification

[jaltwerger]

I have a field that has only 2 entries, yes "y" or no "no." I'd like to run a query that will list only "y," and then count the number of total "y's."


How can this be accomplished?
Thanks

[JoeM]

I'd like to run a query that will list only "y,"

In the Query Builder, just place "y" in the Criteria box under this field.

and then count the number of total "y's."

You cannot list each "y" record individually, and get a grand total in a query. They would be two separate queries.
What you can do is after you create your first query above that only shows the "y" records, create a new query based on this one.
Simply add the "y" to the fields you are displaying (and ONLY this field), and then click on the Totals button (looks like a Sigma).
This will add a "Totals" row under the field in Query Builder with the phrase "Group By" under it. Change "Group By" to "Count", and you will get your count.

If you wish to show each individual record with a total count on the bottom, you would need to do this on a Form or Report.

[jaltwerger]

Thanks, Joel.

In the Query Builder, just place "y" in the Criteria box under this field.

You cannot list each "y" record individually, and get a grand total in a query. They would be two separate queries.
What you can do is after you create your first query above that only shows the "y" records, create a new query based on this one.
Simply add the "y" to the fields you are displaying (and ONLY this field), and then click on the Totals button (looks like a Sigma).
This will add a "Totals" row under the field in Query Builder with the phrase "Group By" under it. Change "Group By" to "Count", and you will get your count.

If you wish to show each individual record with a total count on the bottom, you would need to do this on a Form or Report.