Hi,

I need to run a query to get count of one field, but group by another field with interval value. The query result should get as following:

Fld1 CountOfFld2
1.0~1.9 xx
2.0~2.9 xx
3.0~3.9 xx
...

Do you know if there is a way to query on it?

Thanks a lot for your kind help!

There should be no problem with grouping on one field but counting another. Please provide more information about your structure and data.

Charles