Null values

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

I have two tables and I trying to perform an unmatched
query but there is a slight problem.

some numbers appear

00139
01833
01753

the other table numbers appear (this is how I want the
numbers to appear).

139
1833
1753
64726

Is there a way to trim the zero's above so that they will
appear like the numbers below?
 
Assuming that the numbers are text in one (or both) table, you can use the
CLng() function to convert them to Long Integers, so that they can then be
compared.
 
Back
Top