query

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,


Either you need to remove the record that have a zero, in that case, use a
delete query,


either you need to remove the 0 appearing at the extreme left of a number.
That occurs if you number is, in fact, a STRING (check the data type of the
field), either you "see" a formatted number, through a format, or a mask. In
the first case, change the data type in table design; in the second case,
remove the offending format, or mask.




Hoping it may help,
Vanderghast, Access MVP
 
I need to remove lead zeros from all records of a table
Click to expand...

Well, that depends.

All fields in all records?
What's the datatype of the field(s)?
If you have two records with values 000123 and 0123 is it OK that they
both end up 123?
Do you want to permanently remove the zeros, or just get rid of them
dynamically for a report or display?

John W. Vinson[MVP]
 
Back
Top