grouping by 100's

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
 
R

raskew via AccessMonster.com

Hi Norm -

Your grouping (0 to 100, 101 to 200) is inconsistent, i.e. 100 possibilities
in the first group, 99 in subsequent groups.

If it's feasible to use 0 to 99, 100 to 199 etc., you could add a calculated
field:
int([myfield]/100) * 100
...and group by that.

HTH - Bob
 
J

John W. Vinson

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.
 
Top