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.

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 wrote:
> 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.

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

"John Spencer" wrote:

> 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 wrote:
> > 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.
> .
>