i'll make a comparison between two fields in database(comparison in string) what must I do?
Printable View
i'll make a comparison between two fields in database(comparison in string) what must I do?
strings may be compared directly (alphabetical ordering)
If rs!field1 > rs!field2 Then
if you have some other comparison in mind please specify
how can I compare the first string in record 1 with the first string in record 2. Example. record 1 have 011000 and record 2 have 102100. so, how can we compare the first string (0) with the first string in record 2(1).
Dim str1 as string, str2 as string
str1 = rst("SomeField")
rst.movenext
str2 = rst("SomeField")
Tom Cannaerts
[email protected]
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook