Format column headings in Cross-Tab

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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?
 
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")
 
Back
Top