Reports aren't filtering correctly

[Guest]

Hi -
My table has 2500 employees. Each employee can have a medical claim, dental
claim and prescription claim.

I've created a 4 queries based on the following:
GRAND TOTALS from $1 to $1000
GRAND TOTALS from $1001 to $2500
GRAND TOTALS from $2501 to $5000
GRAND TOTALS from $5001 and above

I've just created a report based on the $1 to $1000 query. I used the
Report Wizard to created the new report, but when I run the report, I get
records that are more than the $500 that I specified.

Any suggestions????

 

[John Spencer]

How are you applying the criteria to limit the records returned to 500 or
less?

Are you getting all the records or some of the records that you don't want
and are you missing any records?

For example are you getting the records = 1000 and missing records for
values in the 60s, 70s, 80s, and 90s? That could be caused by the total
being treated as a text value instead of a numeric value.