G gregtank Registered User. Local time Today, 22:50 Joined Apr 25, 2005 Messages 13 Apr 25, 2005 #1 how can i validate a field so that the data entered must be between the values of 1 and 10? thanks in advance
how can i validate a field so that the data entered must be between the values of 1 and 10? thanks in advance
KenHigg Registered User Local time Today, 17:50 Joined Jun 9, 2004 Messages 13,289 Apr 25, 2005 #2 In table design view, set the fld validation rule to: >=1 And <=10 (And enter some kind of error message...)
In table design view, set the fld validation rule to: >=1 And <=10 (And enter some kind of error message...)
G gregtank Registered User. Local time Today, 22:50 Joined Apr 25, 2005 Messages 13 Apr 25, 2005 #3 thanks very much for you help, it worked a treat!
