Search results

Thanks everyone. Some really good stuff to work on, I clearly have much to learn! I will try these suggestions and see how I get on.

Please see the attached database. I created this with only the basics needed to perform this. As you will see, in tblAgreementRecord there are four records, with two of those records showing a value of 1 for Agreement. I simply want the query to count the number of instances where the value of...

Hi everyone I'm very much a low-level Access user and I am struggling with something I'm sure must be very simple. I am happy with using the Totals function to count records within a query, but when I come to adding criteria (for example: only count the record if a field within the record is a...