I use access and ado in my project.

I need a query to count occurences by a range from a field named Aumont.

this is my request:

How many amount are in the range from 00,01 to 1.000,00
How many amount are in the range from 1.000,01 A 5.000,00
How many amount are in the range from 5.000,01 A 10.000,00
How many amount are in the range from 10.000,01 A 999.999.999,00

naturally for each raneg get the Total of the summ of amount