Access 2003: Automatically Populate Column Headings

[Lmens]

Hello

Can Access populate monthly column heading(January, February,….December) base on date in, for example a “Calendar Date” column (with dates) or I have to Switch or if statement to manually do that?

Many thanks for any help you can give me!!

 

[DCrake]

If you are sing a crosstab query and you column field is a date field you can grop by month and display the month name only.

 

[Lmens]

Thank you.