Problem Creating Totals Query

[Guest]

I have a table that stores different percentages for different people. The
percentages are stored as numbers so 96% is stored as 96 and so forth. I'm
trying to create a query that lists all people and the # of times each person
had a percentage less than 95. I created a totals query with 2 columns: one
column which has the persons name and has Total set to "Group By" and then I
have another column which has the actual percentages and the Total is set to
"Count". In the Criteria line under the percentage column I set the criteria
to "<95". When I run the query though, instead of counting only percentages
less than 95, the query is counting the total # of percentages that exist for
each person in the table even if the percentage is greater than 95. Any
suggestions?

Thanks.

 

[John Spencer]

Add a third column
Field: PercentageField
Total: WHERE
Criteria: <95

Remove the criteria under the count field.

The way you've set it up, it is returning records where the COUNT of records
is less than 95. What you want is a count of records where the percentage
value is less than 95.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..