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.