Don't worry about my time. I only do this when I have the time to spare. As for what I posted, that **IS** the query. It can be confusing to try to post all the stuff in the query design grid (which is just a convenient user interface for creating relatively simple SQL statements). On the other hand, posting a query's SQL view is concise(?) and unambiguous. If I knew the name of your table

Emelina Bumsquash wrote: I'll try and be as clear as possible! I have a database form that has various yes/no criteria answered for various participants. Each of the participants is recruited from 1 of 8 sites; so everyone will fit into a 'site' class (1-8). My queries are very simple and aim to count up the total number of 'yes' for the various criteria i.e. "show me how many