Remove leading zeros

[TeeBruin]

I am trying to modify a database. The only problem is that there's a column with numbers formatted as text in a couple of tables. In one table there are leading zeros, but not in the other table. So, the query isn't working correctly, I'm assuming because it doesn't find a match due to the zero problem. Is there a way to either remove the leading zeros from one table or add leading zeros to the other table(if you want the number to always have 14 digits)??

Thank you in advance for any help.

 

[WildHare]

In the table where the numbers are formatted as TEXT, change the type to NUMBER and add the leading zeros in the FORMAT property instead. In the table, they'll be stored as just the significant digits.

In a number field, 42 is the same as 00000042
if the 0's are added as a FORMAT character.




Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm