I have a query which used to work but now gives me the error “Undefined Function ‘Format’ in expression”. If I take out the Format fuction it then errors on Chr. My guess is that I have a missing reference to a library but which one?
I have gone back to an older version of the database which works OK so its not the query and I can’t see any differences in the references so I have had to move any changed objects back into the older version to solve the problem but any ideas what could have caused it?