Open the table in design view, select the Date/Time field, and set these
properties:
- Validation Rule: ([SatOnly] Mod 7)=0
- Validation Text: Must be a Saturday
Replace the SatOnly with the name of your field.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"jaymalea" wrote in message
...
For example:
03/13/2010 would be fine, as that is a Saturday. 03/12/2010 would return
an
error message as it is a Friday.
How would I create a field property for this, or would I use a different
aspect of Access creation?