Counting Records within a certain range

[jhowk]

I am trying to write a query that will look at my data and tell me how many
records have values between a set of values, how many are below that and how
many are above. I figured the count function in totals would do this, but
when I use it the query doesn't return any data at all

Anybody know what I'm doing wrong?

 

[KARL DEWEY]

Try putting this in the FIELD row of the Totals query grid opened in design
view --
Range 1-15: Sum(Iif([YourValueField] Between 1 and 15, 1, 0))

 

[jhowk]

Thats what I ended up doing and it worked great, thanks alot.

Try putting this in the FIELD row of the Totals query grid opened in design
view --
Range 1-15: Sum(Iif([YourValueField] Between 1 and 15, 1, 0))

I am trying to write a query that will look at my data and tell me how many
records have values between a set of values, how many are below that and how
many are above. I figured the count function in totals would do this, but
when I use it the query doesn't return any data at all

Anybody know what I'm doing wrong?