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

  • Thread starter Thread starter Guest
  • Start date Start date
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 ?
 
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.
 
Use the val to return the number without the 00

=Val(FieldName)

or

Select Val(FieldName) As NewNumber From TableName
 
You must log in or register to reply here.

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
Getting rid of 0's in report 2
trying to insert a 0 in front of zipcode 2
0 in front of numbers in Access 6
Leading with 0's in a table. 3
Automatic Removal of 0's in front of data 1
How to create a sort order number in a query 2
How do I make "2-3453-99" appear "00002-3453-99" in access? 1

Back
Top