[Peter]

Hi,

I have a table where I record faults and errors related to the construction
of a house. Each record is given a priority from 1 to 3. Now, is it possible
to construct another table, and then count the number of priority 1's, 2's
and 3's in the other table (I know about Count() and how to reference a
column in another table, but I can't get it to count records based on a
criteria).

Hopefully someone knows the answer to this one