Hi, I have a database that i have been developing / using for sometime now. I have just rebuilt my PC and when i try out a query i get the error message
"Function isnt available in expressions in query expression"
the part of the query that causes problems is
I have tried re-installing, service packing, re-service packing. Other databases are fine, ie the LEFT expression works as expected.