InstrRev

[Guest]

I'm trying to use InstrRev in a query but its not being recognised. I get an
undefined function message when I try and run the query. Any ideas?

Karen

 

[Brendan Reynolds]

Which version of Access? InStrRev should work in Access 2003. It did not
work in queries in the original release of Access 2000. You *may* be able to
get it to work in queries in Access 2000 by installing the latest service
releases for Office and Jet, if you have not already done so. Failing that,
you can write a custom VBA function that calls InStrRev, and call the
function from your query.

 

[Guest]

Thankyou. Written a function which works perfectly.

Karen