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?