VBA/Make Table Query

[Jameo]

Hi all,

I have an issue with a make table query. maybe someone can help?

I currently have a table populated with a list of sites. The table headers are along the lines of:

Site | Max Capacity | Stock

I have the need to create a table based on the above table, however, I need the new table to have headers listed under the site field. i.e. the new table headers would be:

Site1 | Site2 | Site 3


Not being an Access Guru, I am not sure if this is possible or not. I have quite a bit of experience writing VBA so if it is not possible with a standard query, could this be accomplished by passing an SQL string through VBA?

Any help will be appreciated.

Thanks

 

[alansidman]

I would create a cross tab query and then use it to create a make table query.

Here is a video on how to create a cross tab query.

http://www.datapigtechnologies.com/flashfiles/crosstab.html

Alan

 

[Jameo]

Many thanks for that. Cheers