Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I set up the MOD function as a validation rule?

Discussion in 'Information Technology' started by JheyDC, Jul 28, 2006.

  1. JheyDC

    JheyDC
    Expand Collapse
    Guest

    I hope someone out there can answer this for me.

    I have been trying to set up the MOD 7 as a validation rule but I can't make
    it work.

    I would be very thankful for any assistance given. Thanks.
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Mod is an operator, so it should be possible to use a validation rule like
    this in MyField:
    [MyField] MOD 7 = 0

    --
    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.

    "JheyDC" <JheyDC@discussions.microsoft.com> wrote in message
    news:0856E1E1-7AD4-4D12-9B31-25E33A765A0A@microsoft.com...
    >I hope someone out there can answer this for me.
    >
    > I have been trying to set up the MOD 7 as a validation rule but I can't
    > make
    > it work.
    >
    > I would be very thankful for any assistance given. Thanks.
     

Share This Page