Vertical to Horizontal - Create Table

[kenschmitzjr]

Hello - Can someone help me please....

I have a vertical table that I need to run a select on by Website name and then convert that into a horizontal temporary table to add some invoice data to.

Here is how the data looks:
Site
Processing Fee
Item Tag
Bill Code 1
Bill Code 2....

The fields are sorted by the end user as 1-55...
I need to build a table with the listed information above as the headers in Access. Then I will run an update and through data from many different tables into this freshly made table and output a report.

Does anyone have any snippet of code to help get me started?

Thanks,

 

[CJ_London]

You can can use a make table query on a crosstab query