I have two tables, Client Info and Client Visits. The first table has
general info that does not change so Client info is enter one time only. The
second table records services provided at each client visit. The first table
has Client ID and the second has Visit ID and Client ID. During the month a
client may have several visits. Therefore the Client ID would occur several
times while each visit has a unique Visit ID. For a given month I want to
know how many different clients were seen as well as count the fields of
info. associated with them. At present I am able to get a total of Visits
but not of unique Clients. As you can see, I am a novice regarding ACCESS.

Thank you for any suggestions you may have.