Quick access question

[xaber]

Hi, Does anyone know if there is a function in Access that returns the day of the week of a specified date?

For example day(15/05/06) would return monday?

Had a look through help to no avail!

Thanks

 

[xaber]

Cheers for that m8!

Can anyone else tlel me how you can check whether or not a number is even? Need to perform an validation that only allows dates of every other week. Using datepart I can get the week number, but not check if its even