Format column headings in Cross-Tab

[Jennifer]

I have a cross-tab query that is based off of a master table. The columns in
the cross tab are dates. I formatted the Month column in the master table to
MM/YYYY but the cross-tab column headings read as M/D/YYYY. This messes with
my macros because eventually when I get to October (10) the months will be
out of order. Am I missing some format setting somewhere?

 

[KARL DEWEY]

Open the crosstab query in design view and check the field that is the column
headings.
It should look like this -- Expr1: Format([YourDateField],"mm/yyyy")