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

G

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 ?
 
R

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.
 
G

Guest

Use the val to return the number without the 00

=Val(FieldName)

or

Select Val(FieldName) As NewNumber From TableName
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove 0's in front of numbers? 3
trying to insert a 0 in front of zipcode 2
How to create a sort order number in a query 2
How do I remove the apostrophe(') in front of zeros 3
Leading with 0's in a table. 3
Need help adding a front slash "/" in between numbers that do nothave it. Examples included. 12
put 0 in front of number 6
How do I make a query with dynamic number of coloumns? 8

Top