Query Different choice in the same fields.

[Thinh]

I am trying to create a query that capture all the possible choice of a fields and do some math on them. let me make it clearer.
I have two fields that i need to create a query from forecast type(backup, hardcore) and win percent(76 to 100, 50 to 75, 26 to 49 and 0 to 25).
Forecast type is a drop down that has the following choice hardcore, backup or could be null. Win percent is just a number fields holds value between 0 and 100. One of the criteria for the range of number is when either backup or hardcore is null.i need them to line up as rows or columns so they either look like this

row view

Hardcore
Backup
76 - 100
50 - 75
26 - 49
0 - 25


column view
[Hardcore] [Backup] [76-100] [50-75] [26-49] [0-25]

I am currently using six queries to get the values for each group then joining them to get the final results. the problem with this is the values wont come out correctly. I know there is an easier solution to what i am doing right now.
I need some guidance and help to approach this issue. This will be use in a report so hopefully this provide more alternative to solve this problem.

thanks in advance

 

[raskew]

Hi -

Look-up the Partition() function in your help file.

Bob