How to compare strings

[rickyfong]

How to compare 2 strings in Access in order to determine one is biggest or highest than the other?? For instance, T1212345 vs W1212345. Thanks a lot!!

 

[pr2-eugin]

StrComp is the answer to your Question..

No offense, but you might want to check THIS..

 

[gemma-the-husky]

yuo can just say

if strga= strgb

or if strga<strgb etc

or even compare a few characters

if left(strga, num) = left(strgb, num)