enter a date onto an Access Form to not accept Wednesdays

G

Guest

Office XP.
I want to enter a date onto a form that will accept it only if it is not a
Wednesday.

I can enter the error message "Not a Wednesday", but I can't find the right
syntax for a formula which refuses Wednesday as a day of the week.
 
R

Rick Brandt

rogerc said:
Office XP.
I want to enter a date onto a form that will accept it only if it is
not a Wednesday.

I can enter the error message "Not a Wednesday", but I can't find the
right syntax for a formula which refuses Wednesday as a day of the
week.

Validation Rule of...

Weekday([FieldName]) <> 4
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top