Reverse Cross Tab

[indiana]

I have a table that contains data in the format:



Company | Account | January | February | Etc......

I would like to convert it into the following:

Company | Account | Month

I know I need a Union query but am unsure of the EXACT syntax I need.

Any thoughts?

Also, can I use a Union query on a query rather then a table?

Thanks,

[pbaldy]

Try

SELECT Company, Account, January, "January" As MonthField
FROM TableName
UNION ALL
SELECT Company, Account, February, "February" As MonthField
FROM TableName
...