Change Table Format via Query

[Guest]

If I have a table that looks like:

name partA part B part C
model1 5% 7% 88%

And I want it to look like:
name part amount
model1 A 5
model1 B 7
model1 C 88

Could I use a query to make the change? How would I do that?

 

[S.Clark]

Use an Append Query, run it three times, one for each Part# column. Use a
literal value (i.e. A, B, C) to populate the Part number in the new table.


--
Steve Clark, Former Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html