Newbie Q: on number compare

[Sonia]

Hi,

I need to compare a set of 5 to 7 numbers of 2 digits each with a stored
once in a lottery style.

In other words, I inputs the sets in a field (01-11-19-24-26-31) and then
compare them with ClnN1, ClnN2... in myTable

How would I go by?

TIA

Sonia

 

[Guest]

dim i as integer, j as integer, num as string
i = 1
while i <= len(InputNumbers)
num = mid$(InputNumbers,i,2)
For j = 1 to <number of comparison numbers>
if CLnN1 = num then
...
elseif CLN2 = num then
...
..... etc etc ...
end if
next
i=i+2
wend

-Dorian