Append Query

[Guest]

I am trying to make three append queries (advice from another user). I'm not
sure how to go about it. Any advice based on the info/tables below? Thanks!

TABLE:
name section a section b section c
Model 1 25 30 45
Model 2 ..................

Desired Query outcome: more normalized table

modelNum, section, amount
1,a,25
1,b,30
1,c,45

I am hoping to be able to insert a chart into a report. Each page of the
report is for a different model name and then breaks down the model into
parts:

REPORT:
Model 1
section a=25% section b=30% section c=45% ....

I would like a pie chart to represent the way each model is broken down (one
slice=section a, one slice=section b....)

 

[Guest]

Try this --
SELECT awach.name, "a" AS Section, awach.[section a] as Amount
FROM awach
UNION SELECT awach.name, "b" AS Section, awach.[section b] as Amount
FROM awach
UNION SELECT awach.name, "c" AS Section, awach.[section c] as Amount
FROM awach;