defining Criteria between two dates

[tamu46]

I need to find the number of work orders (Count) that occured between 4/1/05 and 4/30/05. What I typed into the Criteria was "Between 4/1/05 And 4/30/05". But when I run it, it comes back with telling me two different things, the count of work orders for 4/1/05 and 4/3/05. Thats not what i want. I want ALL the Work orders for that month of april. Any Ideas?



Thanks
Brandon

[pbaldy]

What is the SQL of the query? Likely you are grouping on the date field, and you don't want to.