I will start off saying that, yes, I know there is no COUNTIF in Access, and that this question covers a few areas of Access. So here we go:
I have a database which includes a Members Table. Each member has a different type of Membership:
Social,
Lifetime,
Founders,
Junior,
Full-time...