Removing a character

  • Thread starter Thread starter Bill Davis
  • Start date Start date
B

Bill Davis

I have a field that has 5 character ex. N0284 what I need
to do is remove only the zero leaving the N and the last
three digits is this possible using and query?
 
Hi Bill

yes, you can use an update query
option 1 - if you want to overtype the field with the modified values
create a query, change the type to update query
add the field to the query grid (assume name is "inhere")
in the Update to line type
Left([inhere],1) & Right([inhere],3)
run the query

option 2 - if you want to put the value in a new field (assume new field is
called "NoInHere")
create a query, change the type to update query
add the new field to the query grid
in the update to line type
Left([inhere],1) & Right([inhere],3)
run the query

Good luck

Regards
JulieD
PS before trying any solution which modifies data in your tables, ensure you
have a backup :)
 
Julie,
That work great.. Thank you
Bill
-----Original Message-----
Hi Bill

yes, you can use an update query
option 1 - if you want to overtype the field with the modified values
create a query, change the type to update query
add the field to the query grid (assume name is "inhere")
in the Update to line type
Left([inhere],1) & Right([inhere],3)
run the query

option 2 - if you want to put the value in a new field (assume new field is
called "NoInHere")
create a query, change the type to update query
add the new field to the query grid
in the update to line type
Left([inhere],1) & Right([inhere],3)
run the query

Good luck

Regards
JulieD
PS before trying any solution which modifies data in your tables, ensure you
have a backup :)


I have a field that has 5 character ex. N0284 what I need
to do is remove only the zero leaving the N and the last
three digits is this possible using and query?
Click to expand...


.
Click to expand...
 
Back
Top