Function not available in expressions in query expression?!
> Hi all,
> Recenlty I decided to open up an access database I haven't used for a while.
> When I tried to run a predefined query I got the error 'Function not
> available in expressions in query expressions' with the expression between
> parantheses behind it. This used to work and this error even appears when I
> do very simple text functions like rtrim$ on a string field.
> I haven't got a clue what is wrong here. As mentioned this used to work. I
> have reinstalled my PC a while ago, but office was installed fully.
> Any help is appreciated!
This is a references problem, have a look here for the solution:
and look at the first item
Hope this helps