Simple Problem?

  • Thread starter Thread starter S_Workman
  • Start date Start date
S

S_Workman

Guest
Hi all

I need to append a table that is itemized Vertically to a table that is itemized horizontally:

A Simple example:

Starting Table:

Name | Car

Alan | Blue Car
Alan | Yellow Car
Alan | Red Car
Alan | Green Car


New Table:
____________________________________________________________
|Name____|____Car1____|____Car2____|____ Car3____|____Car4 ____|
|Alan_____|___Blue Car__|__ Yellow Car_|___Red Car___|__Green Car__|

Any Help appreciated as i dont know where to start.

Thanks.

Scott.
 
scott,
Why not create a crosstab query and leave your table alone? The resulting query will display just as a table opened in datasheet view.
jim
 

Users who are viewing this thread

Back
Top Bottom