Carl,
You can use
int(field/10) as nGroup to get that kind of grouping.
>That would give me the number of occurences by grouping. Unfortunately it's a little more than that. What we're trying to do is (within one statement) get conditional counts for ranges. For instance, one count if the field is from 0 - 9, another if 10 - 19, etc. without having to generate a grouping indicator in advance. Ultimately we are trying to create a report with columns meeting certain criteria.