Update query - Compile Error

[Quempel]

I have a field that includes "DR" in front of the data. I'm trying to build an update query to remove the DR from data. Here is what I have tried:

Left$([account],InStr(1,[Account],"DR")-1)

Left([account],7)

Both gave me a compile error.

What am I doing wrong?

Thanks in advance for any help that you can provide me.

 

[Remou]

If Account = DR12345

Mid(Account,3)=12345
Left(Account,2)=DR

Is this what you mean?

 

[Quempel]

Actually I figured it out....thanks for help though.

Data - account = DR12345

To remove the DR I have to use the "right" and correct function. Right([account],5)

 

[Remou]

I hope you included a Len in the Where statement.