Report sorts Date Field as Text

[SmellyMelly]

I've got a report which sorts the date field as text. The underlying query has formatted the date from DD/MM/YYYY to MMM, however when I use the formated query field in the report, it is treated as text (ie sorts alphabetically). Any ideas how to tackle this?

 

[smedvid]

Just a thought... since it is a report. Update the query to include the field again in a date format. Then use that field to sort. U can hide (or display) the field on the report. htwh Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...