Newbie Q: on number compare

  • Thread starter Thread starter Sonia
  • Start date Start date
S

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
 
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
 
Back
Top