What expression can change Hogsback Unit 34-9 to Hogsbk 34-9?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm trying to manage a large database of information. I'm trying to find
out how I can remove certain parts of a field...ie. Hogsback Unit 34-9 to
Hogsbk 34-9. I realize this would take two separate functions...one to
remove the "ac" from Hogsback and another to remove "Unit". Thanks for the
help.
 
create a query (then go into design view and change it to a update query)
on the field that would contain your term:
update to: Hogsbk 34-9
Criteria: Hogsback Unit 34-9

then run the query and it should find every occurance of Hogsback Unit 34-9
and change it to Hogsbk 34-9.
If you don't want to warn you and prompt you, you can make a macro with the
Set Warnings (set to no) and then add the open query to the macro. Then just
run the macro from a button or whatever.

Later,
_Bigred
 
Back
Top