Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comparing Fields to Find If More Than 2 Colors Selected

Status
Not open for further replies.

vbreezy

Programmer
May 18, 2001
5
US
(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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top