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

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

Guest

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.
 
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.
 
Back
Top