expression

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

Guest

I have this expression Replace(mid([NSN];5);"-";"") in an update query which
updates a NSN from 1111-22-333-4444 to 223334444. Works great in office 2003
but replace function doesnt exist in office2000 so my question is, is there
an expression in office2000 update query I can use to do the same job?
 
The Replace function does exist in Office 2000 but (at least in the original
release) can not be used directly in queries. You may find that installing
the latest service releases for Access and Jet may enable you to use the
function in your query, or failing that, you can write a custom VBA function
that calls Replace, and call the VBA function from your query.
 
Back
Top