Compare multiple values
Posted on 2006-11-21
I have two datatables:
tbl_PlayersNumbers (multiple records)
Columns - UniqueKey(PK)(Autonumber), Players1(int), Players2(int), Players3(int)
tbl_WinningNumbers (one record)
Columns - WinningDrawing(PK)(date/time), Winning1(int), Winning2(int), Winning3(int)
Next I need to compare Players1 to Winning1, Players1 to Winning 2, etc This covers all possiblities of Players and Winning. Each time that a combination matches, I need to add 1 to a varible called "Matched". Then loop thru each record in tbl_PlayersNumbers.
I think I can do this with If/Then statements but there has to be a better way. Thanks for any help.