Cross Tab by Day

[Guest]

I have set up a CrossTab Q that the user can only pull one weeks of data
Sunday - Saturday. At this time the CrossTab comes back with the Dates. I
would like the Format to be a Day only format. Sunday, Monday, Tuesday Ect..
Then I could have it feed a Report. At this time the dates change for each
week so I cant make the report.

How could I set the Date format in the CrossTab so that it gives me only the
day?

Thanks

 

[Duane Hookom]

Set the column heading expression to Format([DateField],"dddd"). Make sure
you filter your records to only one week.

 

[Guest]

Thankyou for your help Duane!!

Set the column heading expression to Format([DateField],"dddd"). Make sure
you filter your records to only one week.

--
Duane Hookom
MS Access MVP

I have set up a CrossTab Q that the user can only pull one weeks of data
Sunday - Saturday. At this time the CrossTab comes back with the Dates. I
would like the Format to be a Day only format. Sunday, Monday, Tuesday Ect..
Then I could have it feed a Report. At this time the dates change for each
week so I cant make the report.

How could I set the Date format in the CrossTab so that it gives me only the
day?

Thanks