Get rid of zeroes in a table

W

www.ttdown.com

I have a table that is imported from a .csv file. One of the fields
is a numeric field and holds the numbers 0-9. I'd like to write a
query that would get rid of all the 0's and leave the fields that
contained the 0's empty without disturbing the fields that contain the
numbers 1-9. Can anyone help?

Thanks!
 

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

Deleting 0's in a table 1
trim leading zeroes / change data type 2
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
Multiple Table Search 15
Remove Zeroes in front of a number - help! 3
Access 2010 AND Query Help 1
Adding Information to a Table 3
Serial Number - Temporarily In A Query 7

Top