yes, that is exactly what i'm trying to do. attached is a screen shot of the design view of one the queries. i want a count of the field within a date range. i tried the code listed above and access returned "this expression is typed incorrectly, or is too complex to be evaluated". i feel like...