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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expression 7
Update Query expression 2
Duplicating values to empty field 6
Search by product & alsoshow other products purchased by same cust 2
Using "replace" in update query 2
Summarizing worksheets 2
Replace function 4
Mid-function does not look at length parameter 0

Back
Top