Convert Weekday from # to Descriptive "Mon"

  • Thread starter Thread starter Ralph Wischnewski
  • Start date Start date
R

Ralph Wischnewski

I have a feild in a report that shows the day of the week
as a date feild using the "Weekday" function. I would
like the report to show "Mon" rather than "2". How do I
achieve this?

Thank you
 
Ralph said:
I have a feild in a report that shows the day of the week
as a date feild using the "Weekday" function. I would
like the report to show "Mon" rather than "2". How do I
achieve this?
Click to expand...

Use the Format function instead or the WeekDay function.

Format(datefield, "ddd")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weekday Trend Report 1
Help with customizing report using VBA (an looping through weekdays) 3
Please help..Need a report due within 7 Weekdays 3
How to create a report in Access that would use a date range 8
Creating a report 1
Calculate in report or Query? 3
Next weekday ... 3
Loop 1

Back
Top