Getting the actual date from a crosstab column heading

[sponge]

Hi,

I have a crosstab query that groups by week to obtain columns for monday to sunday. Is there a way to obtain the actual dates that these columns represent?

Any help would be much appreciated.

 

[SamDeMan]

cdate() or something similiar. please post your format.

you can try a combination of month([YourDate]).. and then Format(Month([date]) & "/" & day....

sam