How do I convert a weekday number to a string?

[Michael Hannan]

I'm using the Weekday function to produce the day of the week (integer); I
want to convert the integer to a string, for example, 1="Sunday." The
function is working but I'm getting a type mismatch error. Help!

 

[Douglas J. Steele]

To get the name of the day, don't use the Weekday function. Instead, use
Format([DateField], "ddd") to get Sun, Mon, Tue, or Format([DateField],
"dddd") to get Sunday, Monday, Tuesday...