Count total number of records and specific records in a query column

[IzzyKap]

I am a newbie to Access DB and am stuck trying to count total records in a query column as well as those that fit a specific criteria within that column. For example, I have a column, ClientSt, representing different US states where my clients are based. I would like to be able to get a total client count for the ClientSt column and then get a count of clients from a specific state, eg AL. Any help is greatly appreciated.

[June7]

Are you building an aggregate (GROUP BY) query?

Create a field with expression. Try:

AL: Sum(IIf([ClientSt]="AL", 1, 0))

Or GROUP BY on ClientSt and use DCount() to return count of all records in table.

Alternatively, build a report that uses Grouping & Sorting with aggregate calcs functionality. This will allow display of detail records as well as aggregate calcs in group header/footer.