Counting Records within a certain range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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))
 
Thats what I ended up doing and it worked great, thanks alot.

KARL DEWEY said:
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 said:
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?
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting number of records based on criteria 2
Access Count dates within a Month 4
Record Count Variation 4
Union and group, then count 1
Count within a specific range 9
Excel VBA - counting cells by colors and names to it in two different rows. 0
Count in a query 2
Counts within a given range or criteria 2

Back
Top