This must be so easy, number ranges

[C2680mor]

I know this must be so simple, but I banging my head on the wall to find an answer.

I have a table with a list of company details including employee numbers - this is a number not a range.

I need a query to produce a list of the companies up to 20 employees (easy use the < option) and then ranges of 21-50, 51-75 .....

How is the query set up to search for the numbers being between these two levels.

Any help is greatly appreciated (I also know it will probably be very obvious!!)

Thanks

Chris

 

[KenHigg]

How many ranges will there be?

kh

 

[C2680mor]

Only 4: 0-20, 21-150, 151 - 500, 500+

 

[KenHigg]

Between 0 and 20


???
kh

 

[C2680mor]

I will explain it more simply, each company in the table has a entry to show the number of employees they have.

I want to create a querry that finds all the companies that have between 21 and 50 staff. Another to find those that have between 51 and 200 staff etc.

Hope this helps,

Chris.

 

[KenHigg]

Use the between statement in the query as a criteria on the number of employees fld.

???
kh

 

[C2680mor]

See I said it would be easy!!!

Thanks for the help.