Simple Problem?

[S_Workman]

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.

 

[oldaf294]

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