in Access I am trying to return the TEXT day of the week in a quer

M

Marc

I am currently using a query in a database that returns the day of the week
in a numerical format using :

exp1: Weekday([date_of_course],2)

what do I need to do to this to return a text format such as Mon,Tue etc.??

If anyone can help this would be great.... Im a bit stuck on this.
 
M

Marc

Yep it worked!!!

wow.... you're good!

thanks

Rick B said:
expr1: Format([date_of_course],"DDD")



--
Rick B



Marc said:
I am currently using a query in a database that returns the day of the week
in a numerical format using :

exp1: Weekday([date_of_course],2)

what do I need to do to this to return a text format such as Mon,Tue
etc.??

If anyone can help this would be great.... Im a bit stuck on this.
Click to expand...
Click to expand...
 
Top