Format column headings in Cross-Tab

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?
 
K

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Crosstab column headings for conditional formatting in report 0
Sorting in a Cross Tab Query 2
Cross-Tab Query 2
Crosstab - what if I don't want my column headings grouped? 4
CrossTab Query How Do I change Column Headings... 2
SQL question - Cross Tab query 2
Cross tab query solution 4
Cross Tab Query with Different Column Headings 3

Top