Access function same as Excel's FIND function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aron - 19 May 2005 18:34 GMT

Hello,
I need to find a way to replicate what Excel does with the Find function.
Any help will be very much appreciated
Aron

Reply to this Message

Aron - 19 May 2005 20:42 GMT

Here is aome more info:
I want to delete the first word in one field
in Excel i would use this function to delete the first word in A1
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
I tried to do it in a ms access query and it gave me an Error: undefined
function 'Find' in expression
Any help will be very much appreciated
Aron

Reply to this Message

John Spencer (MVP) - 20 May 2005 00:51 GMT

Lookup the INSTR function, and MID

Mid([YourField],Instr(1,[YourField]," ") +1)

However, I would suggest you check to see if there is a space in the string
first, either using criteria or an IIF statement

IIF(Instr(1,[YourField]," ") > 0, Mid([YourField],Instr(1,[YourField]," ") +1))

> Here is aome more info:
> I want to delete the first word in one field
[quoted text clipped - 4 lines]
> Any help will be very much appreciated
> Aron

Reply to this Message