Crosstab Date Column Heading

  • Thread starter mattc66 via AccessMonster.com
  • Start date
M

mattc66 via AccessMonster.com

Hi All,

I have created a crosstab of a sales forcast. I want the Column Heading to be
the Month and Year. What is showing is: 'JAN','FEB','MAR','APR','MAY','JUN',
'JUL','AUG','SEP','OCT','NOV','DEC'

Current Setting:
Format([FC_DATE],"mmm"). The Field [FC_DATE] contains the full date.

How would I format the cell to get the Month and Year. I tried MM/YYYY and
MMM/YYYY and MMMM/YYYY.

Non of that is working.

Thanks
Matt
 

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

Top