(Access 97) I have four fields (Add1, Add2, Add3, and Add4) which each contain a color. I need to somehow check these four fields to make sure there are only two different colors used between the four fields. Does anyone know of any easy way to do this other than having tons of if/nested if statements?
Any help would be appreciated.
Vicki
Any help would be appreciated.
Vicki