how do I remove 0's from in front of a number. 00012 to 12

[Guest]

I have a data base thet has a list of numbers of

zipcode city # of persons

75204 Dallas 00284
64784 xxxxxx 00023

how do I remove the 00's in the third row ?

 

[Rick B]

Where? In a form? Report? Query?

What kind of field is it? If it is a numeric field, then it should not show
leading zeros. It sounds like you have your field defined as a text field.
Change it to a number.

 

[Guest]

Use the val to return the number without the 00

=Val(FieldName)

or

Select Val(FieldName) As NewNumber From TableName