'Function not available....' error...

[Bronte1226]

OK, I have a query that I use to remove unneeded numbers and spaces from a text field. This has worked for months until now. For some reason it will not work now. This is the 'Update to' field:

((Mid([JOEREP020905]![ACCTNUMBER],4,3)) & (Right([JOEREP020905]![ACCTNUMBER],3)))

The error I get is:

Function not available in expressions in query expression '(Mid([JOEREP020905]![ACCTNUMBER],4,3)) & (Right([JOEREP020905]![ACCTNUMBER],3)))'

I have tried splitting it up into two queries, no luck. I even tried a simple RTrim function, still nothing. Is my database corrupt? What could have happened? (The Trim function works in a different database!)

 

[PHV]

Check the references:
When in VBE (Alt+F11), menu Tools -> References ...
If no missing reference, untick one library, close and reopen the dialog box and retick the library.
You may also compile your code (menu Debug).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244