[AccessD] Day of week as name

On 29 Mar 2006 at 19:01, Joe Hecht wrote:
> 
> weekdayname(txtACCIDENT_dATE,,vbUseSystemDayOfWeek)
> 

Weekdayname takes a weekday number (1-7), not a date.

Use
Weekdayname(weekday(txtAccident_Date))
or 
Weekdayname(Datepart("w",txtAccident_Date))
or
Format(txtAccident_Date,"dddd")

-- 
Stuart