I have been using a query in Access 97 without any problems. I have moved up to Access 2000 and the following field in a query brings up an error "Undefined function 'Mid$' in expression:
Descr Second: Mid$([mg_descrn],[Second Word Descr]+1,5)
I have checked it against the original Access 97 version and there is no difference.
Can anyone please help me?