grouping by 100's

  • Thread starter Thread starter norm
  • Start date Start date
N

norm

I have a query that returns a range of vehicle numbers, it possible for it
to give me count of vehicles that fall between: 0 to 100, 101 to 200, 201 to
300 and so on. Is this possible? I ytied using a crosstab query but I have
too many records (about 10,000) Yes I work for large fleet.

Thank you for your time
Norm
 
I have a query that returns a range of vehicle numbers, it possible for it
to give me count of vehicles that fall between: 0 to 100, 101 to 200, 201 to
300 and so on. Is this possible? I ytied using a crosstab query but I have
too many records (about 10,000) Yes I work for large fleet.

Thank you for your time
Norm
Click to expand...

Put in a calculated field:

[vehicle number] \ 100

The \ integer-division operator will give a 0 for 0-99, 1 for 100-199 and so
on; you can group or crosstab by that calculated value.
 
Back
Top