Hi all.

I can complete this in excel no problem with monday through sunday being 1 -7, but is the same possible in access.

i.e. 12/03/08 = Wednesday.

Many Thanks Dean:confused:

Update:

DoW: Weekday([Calldate],0)

DoW: Format([Calldate],"dddd")

be careful of your constants

access has a set number of constants for days and sunday is 1

look at vbsunday , vbmonday etc in help
(maybe under weekday function)