Hi there. I am trying to calculate the day from a date. I apologise for not knowing the correct function, but have not used Access for some time. Many thanks

David

strDay= Format(strDate, "dddd") will give you the day.

Check out the function "Weekday" for more advanced calculations.

Thanks a lot John