E
Eric J Owens
A2k running on win2k adv serv (sp3)
In a calculated field I have:
NewName:
Replace([router].[name],Left([Router].[Name],InStr([Router].[Name],"_")-1),[
router].[sitecode])
but get an error (ref. subject of post). While checking to ensure the
expression was returning what I wanted, i worked from inside to outside of
expression to test and the other functions work fine. I tried the procedure
proposed by John Vinson's 7/9 reply post (check/uncheck references so access
will re-link), but this did not help. Also, KB310803 didn't seem to work
out either (re-registering a dll).
Any help would be greatly appreciated.
In a calculated field I have:
NewName:
Replace([router].[name],Left([Router].[Name],InStr([Router].[Name],"_")-1),[
router].[sitecode])
but get an error (ref. subject of post). While checking to ensure the
expression was returning what I wanted, i worked from inside to outside of
expression to test and the other functions work fine. I tried the procedure
proposed by John Vinson's 7/9 reply post (check/uncheck references so access
will re-link), but this did not help. Also, KB310803 didn't seem to work
out either (re-registering a dll).
Any help would be greatly appreciated.