Access function same as Excel's FIND function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I need to find a way to replicate what Excel does with the Find function.
Any help will be very much appreciated
Aron
 
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
 
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))
 
Back
Top