Create a crosstab query with code?

[mmr3b9]

Hi,

I need to create a crosstab query using vba code. I have a table with six fields. I need to have two fields going vertical and one horizontal and another field summed is the data.

Im using Access 2000. A sample of the final outcome would look like the data below:


Year Month 210000 236000 237000 238000
1990 1 2 341 188 993
1990 2 0 325 169 940
1990 3 1 343 174 979
1990 4 3 321 263 1076
1990 5 1 354 305 1228
1990 6 1 375 375 1300

Thanks,
Mike

 

[rss01]

heres a couple links that might shine some light.

http://www.sqlteam.com/item.asp?ItemID=2955

http://www.microsoft.com/officedev/articles/movs309.htm