Calculated Control With a Query that Counts

[koper]

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!

[weekend00]

The simplest counting query is:

select count(*) from tableName where (age between 38 and 40) and color="blue"

[koper]

Thanks I will give it a try. What is the * in the "count(*) for? Is it just a place holder?

[koper]

Doesn't the expression have to begin with the = sign and then don't the field names need to have brackets?

[weekend00]

"*" means everything.
you can add "[]" if you like.
between ... and ... don't need other sign.