hHow do a count the amount of numbers in a cells greater that a c.

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

Guest

I would like to count the numbers in a column that are greater than a certain
value,
I.e. how many numbers are more that the value 30 for instance
 
Well, you don't really explain where you want to do this. In a query? In a
report? You use the term 'cell' which is not an Access term, but a
spreadsheet term. Hopefully you are using Access here and not Excel.

If it were me, I'd create a query and limit it to only include records
greater than 30 by putting criteria under the field desired like...
30
Click to expand...

Then, I'd look at the total number of records selected when the query runs.


You could also cause the query to count the number and return that value.
You could create a report with totals. Lots of options here.

Rick B
 
Back
Top