I have an online form that users fill out and upon submission the data
goes to an MS access database on our server.
One of the fields asks for the date a student needs to take an exam.
The students know they should only use the online form if they are
scheduling at least 2 weekdays ahead of time, however, the form
doesn't currently have a way to reject a submission that breaks the 2
day rule.
Can anyone help me with a query where the data in the date field is
compared to the current date and accepted or rejected based on the
'Must schedule at least 2 WEEKDAYS ahead of time' rule?