instrrev function missing 1

[blutimus]

hello:

im trying to use the instrrev function in a select query. i dont see it in the list of available functions. i can use it in a module however.

i would like to have this function available by default in all my access dbs. is there any hope?

thanks

blute

 

[Remou]

Hi
Do you mean in the list of functions available in the Expression Builder? I tried InStrRev in a text box (Access 2000) and it worked fine. Here is the syntax, if you don't already have it:
[tt]InstrRev(stringcheck, stringmatch[, start[, compare]])[/tt]

 

[blutimus]

yes, i mean the expression builder... sorry. i want to use it in a query. are you able to do that?

i thought maybe my access 2000 didn't include this function.

btw, thanks for thr prompt reply.

b

 

[Remou]

Yes.
[tt]SELECT InStrRev([Firstname],"a") AS ThisIsInStrRev
FROM Members;[/tt]
You are welcome.

 

[blutimus]

is it possible to include this function in the drop-down box of the expression builder, like inStr, so i can use it in design view of queries?

should it already be there?

e

 

[Remou]

This

http://support.microsoft.com/default.aspx?scid=kb;en-us;225956

might help. If you create a function as suggested, it will appear in the list of functions for your database (just under built-in functions). Best I can do I'm afraid.