Compare the "varchar" values

[Tim]

I need to compare the student's score with the requirement score. The problem
is the score is either a varchar value, i.e., "2" OR is combined by two
varchar values, such as "2" and "+" or "-" like "2+". If a student's score is
lower then the req score then the student is not qualified. How to compare
them in VBA?
Thank you in advance for your help.

 

[John Spencer]

I would force the values to increase or decrease based on the presence of the
+ and - signs and then compare the numeric values. Using Replace and Eval you
could use an expression like the following for the comparison.

Eval(Replace(Replace(Score,"+","+.1"),"-","-.1")) >=
Eval(Replace(Replace(Required,"+","+.1"),"-","-.1"))

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Tim]

Thanks a lot. It's smart way to deal with this specific issue.