Cross Tab by Day

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Set the column heading expression to Format([DateField],"dddd"). Make sure
you filter your records to only one week.
 
Thankyou for your help Duane!!

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

--
Duane Hookom
MS Access MVP


KAnoe said:
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
Click to expand...
Click to expand...
 
Back
Top