Counting Criteria in Report (Access 2000/SR1)

Topic

New Reply

I am trying to count groups of test score data in a report. I have four ranges of data I want counted. Numbers from 0-25, 26-50, 51-75, 76-99. I have a test year field I am grouping on. I have tried using Greater than in various count functions in the un-bound text field. The latest I’ve used is: =IIf([Sat9English]>75<100,Count([Sat9English]),0) for the last range 76-100. I cant' get it to work. Any help would be great.

Thanks
Carleton W

Reply | Quote

Replies

Use two queries.

In the first query create an expression along the lines of Abs([Sat9English]>75 and [Sat9English]<100). That will give you a 1 or zero value for each record. Create a similar expression for each grouping you wanted to count.

Then create a second query based on the first and make the second one a group by query. Now you can use the Sum aggregate function to total each expression, and that will give you the count.

Reply | Quote

Or, check out my new favorite hidden function: Partition(). You can use it to group your scores into ranges that you define, then count the number of occurences in those ranges. It’s a great function, check it out in Help.

Reply | Quote

Thanks Charlotte it worked perfectly. It was so simple it was brilliant….

Carleton

Reply | Quote