Validation Rule

[stemar]

I'm halfways competent in Excel, but trying to migrate to Access is giving me migraines!

I have a table with a date field and I want to restrict entries to Sundays. I presume I should be using the WeekDay function, but I can't make it work.

I'm sure it's dead simple, but !!

Thanks for your suggestions

 

[Dugantrain]

You can use the Weekday function as a Validation Rule:

Weekday([Your_Date_Field])=1

Replacing "Your_Date_Field" text with the name of the date field. The result of the Weekday function will always be an integer between 1 and 7 and 1 is the result of a Sunday Date.

 

[stemar]

Many Thanks