Crosstab query

[Guest]

I need to know the syntax to do crosstab query in VBA.
I have one table has the format

Item Period Qty
1111 1/1/2003 10
1111 2/1/2003 20
1111 3/1/2003 30
2222 5/1/2004 20
2222 6/1/2004 10
2222 7/1/2004 30

and want to output the data to another table as

Item month1 Month2 Month3
1111 10 20 30
2222 20 10 30

Please note that the time period for each item doesn't start from the same time,

Any help are very appreicated,

 

[Duane Hookom]

How do you calculate the start month? Is the start month the earliest month
for the Item? Does the month cross years?