count items in a column that fall within a range in a report

A

AccessBob

Ten lot sizes in a column. I need a formula that give me the number of lots
that fall within a range. Example: Between 2,000 and 6,500. I want to do this
in an Access report.
 
D

Duane Hookom

Use an expression in your reprot footer like:
=Sum(Abs([LotSize] Between 2000 AND 6500))
This assumes you want to display details in the report as well as the range
count.
 
Top