C
CharlesMTF
Guest
New to the list, and hoping I can get some help on a few issues I'm having in Access 2003.
I have a table where two fields represent log numbers. The fields are called "LogNo" and "LogNoPct". On occasion, the person entering the data will accidentally place the same number into both fields, which is clearly a mistake. One record should never have the same log number in both fields. So, I set up a validation rule for "LogNoPct". I just want it to check the last 4 digits of the log number and not allow the entry if both have the same last 4 digits. In the validation rule for "LogNoPct" I have this:
Everything looks good until I try to save the changes to the table's design. When I hit SAVE I get this error:
Have no idea why its giving me this error. Any help is greatly appreciated.
I have a table where two fields represent log numbers. The fields are called "LogNo" and "LogNoPct". On occasion, the person entering the data will accidentally place the same number into both fields, which is clearly a mistake. One record should never have the same log number in both fields. So, I set up a validation rule for "LogNoPct". I just want it to check the last 4 digits of the log number and not allow the entry if both have the same last 4 digits. In the validation rule for "LogNoPct" I have this:
Code:
Right([LogNo],4)<>Right([LogNoPct],4)
Code:
Invalid SQL Syntax - cannot use multiple columns
in a column-level CHECK constraint.