imposing a ranges on a query

[Guest]

I'm tring to develop a query that split a range of data ( score marks (%))
into ranges of 0%-10%,11%-20% etc.

Ive tried using the partition function, but because there are ten columns
that needs partitioning, I need to write 10 querys.

Is there a way in which I can define the 0-10%, 11-20% column without having
to use a partition statement, hence allowing me to split the ten columns of
data in one query?

 

[[MVP] S.Clark]

You could write VBA code to step through each field and run the query. But,
I have a feeling that you have some normalization issues with the ten
fields, so maybe by only having to deal with 10 queries, you're getting off
light.