I am interested in designing a query that will count the number of records that meet specific requirements. I want to be able to count the number of records where one or more fields meet certain requirements, such as where the age field is between 38 and 40 and the color field = blue. I am sure this is fairly trivial but I just can't see how to do it. I can see how to use a calculated control add numbers in a field together.
Thanks!