Capture Specific Number

[brin]

How is it possible to capture a list of numbers wher met by a ceratin criteria i.e.

List of numbers
7
9
5
6
1
6
1
How can i count/show the number of times a number is greater than 4 in this case we have 5. And is possible to add up those numbers?

 

[jtvcs]

See previous response in your other similar thread concerning sum.

To count... In a query use the field tat has the numbers, click on the Totals button (looks like a funny 'e') on the toolbar in the query design window, then in the grid row Totals, select Count, set your criteria to >4 and the answer when you run the query will be your 'Count' of the values that you want.

Good luck.