Format the date text box

[huertalm]

i have created one multiple-column report that will display an employees stats by either week, month, quarter, or year depending on what the user selects. everything works fine but the column heading (which is the date) always displays as the last day. example if the latest stats entered on an employee were on the 15th of march when i pull up the report with the "month" option it will display jan31, feb28, and march15 as the column headings. this is of course good if i choose the "weekly" option but i want it to display "jan", "feb" and "march" for the monthly option, "qtr1", "qtr2, "qtr3, "qtr4" for the quarter option and just the year for the year option. is this possible?

 

[alkrm]

Create a queries of the wanted date duration based on the source table ,"use wizard so u can select the date display weekly,mothly....etc"
create reports based on that queries and ur problem is solved.