Two Column Table

  • Thread starter Thread starter R. BRADFORD THOMAS
  • Start date Start date
R

R. BRADFORD THOMAS

Good Afternoon,
I am using Windows 2000 and Access 2000. I have a table with 20 records.
Each record has two columns. I want to use a query and make a table with
ONE record having 40 columns. I.e:

Column 1 Column 2
Record 1 is Name Oak Tree
Record 2 is Description Tall and green
Record 3 is Place Front Yard
...
...
Column 1 Column 2 Column 3 Column 4
Column 5 Column 6
New Record 1 is Name Oak Tree Description Tall and Green
Place Front Yard

How can I do this?????????

Brad
 
I want to use a query and make a table wit
ONE record having 40 columns.<

See CROSSTAB in the online help. That's just what it's designed to do

John W. Vinson/MVP
 
Back
Top