Leading zeros in a text field???

[ddbrook]

I have a text field but outputs numbers...
I need the leading 2 zeros taken off. I have tried trim.
I have a query and my data outputs like this:

Meter #,
0054641

I need it to look like:
54641

Please help...

Thanks,
ddbrook

 

[OhBother30]

=right([meter #],4)

 

[snoopy75]

Wouldn't it be =right([meter #],5)??

 

[pgk]

Hi,
Try the following code. It will remove all leading zeroes.

Do While (Left(Text1, 1) = 0)
Text1 = Right(Text1, Len(Text1) - 1)
Loop

Hope it helps. Let me know what happens.
With regards,
PGK