grouping records in a query

[hate_excel]

hi,i have a field with "cycles" i want to make the query group records by every 100 cycles (e.g(0-100, 101-200) etc and give me average values for the data at these points. i know how to get the averages. the only problem is how to make it group the records.

hope you can help.
thanks
ben

 

[SydneyGeek]

You could try creating a field in your query that makes a Cycle Group:
=INT([Cycle]/100)+1

Then group by this field, and grab the average of the Cycle field in the grouping

Denis

 

[hate_excel]

that sounds like an excellent idea...i will try it now....just crazy enough to work....