Wonder if anyone can help? I want to update a field in a table with the position of a character from one of the other fields. In Access 97 I would have written something like:

InStr(Trim([Employee]),")")

Although I've never previously tried in in an Update Query I would have thought it would have worked. Having tried this in Access 2000 it doesn't work ("Can't update records..."). The field is set to Number not text.

I've searched through the help files but am none the wiser, however both Mid(Trim[Employee],4,4) and Left(Trim[Employee],4) work

Regards

Russ (Programing on L plates..!)

__________________
Regards

Russ (Programing on L plates..!)

Try one of the following & post a reply to say whether these have worked or if the issue's still outstanding please:

InStr(cstr(Trim(cstr([Employee]))),")")

InStr(Trim([Employee]),")",0)