Query question

[jscriptor09]

Hi

I have a table (inherited) with several fields. The key ones I am dealing with is

GRADE, REGION and SCORE

GRADE is Poor, Average, Good, Excellent.
REGION is North, South, East, West.
------------------Sum(North)--------Sum(South)--------Sum(East)---------Sum(West)
Poor-------------15---------------------45----------------23--------------------83
Average---------11---------------------12----------------43--------------------22
Good------------02---------------------44----------------33--------------------55
Excellent--------12---------------------14----------------31--------------------75



So what I am dealing with is every time a region is voted a SCORE, Region category get a zero(0) or one(1)
and we are suming up to make the table above.

the SCORE for Average is for 70 to 80
I need to split into Low Average (<= 75) and High Average(>75 to 80)

I am trying to construct this table
------------------Sum(North)--------Sum(South)--------Sum(East)---------Sum(West)
Poor-------------15---------------------45----------------23--------------------83
Low Average-- -06---------------------06----------------23--------------------10
High Average---05---------------------06----------------20--------------------12
Good------------02---------------------44----------------33--------------------55
Excellent--------12---------------------14----------------31--------------------75

I am struggling to get this working. I tried compounded select and I tried union. Neither worked.
Any help doing this query would appreciated

thank you
Mike

[June7]

You are trying to create 2 records where there is currently only 1. SELECT queries don't create records.

Is this your raw data table? Looks like a CROSSTAB query. Show raw data.

I don't understand where the 70 to 80 comes from.