Search and replace with a query - Access 2003

Discussion in 'Software' started by Refurb, Jun 21, 2006.

  1. Refurb

    Refurb Private E-2

    I want to use a query in Access 2003 to find all occurences of dashes ("-") and spaces in a model number and replace it with nothing (remove the occurences). A simple search and replace with an open table but you have to be able to do this with a query.

    Also any hint towards also doing this with VBA would be appreciated.
     
  2. Wookie

    Wookie Sergeant Major


MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds