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