Built-in FIND() function in Access?

  • Thread starter Thread starter angelasg
  • Start date Start date
A

angelasg

I am trying to do something in Access that I'm used to doing in Excel.

I'm building an expression in a query. I want to separate a string
containing a hyphen into its right and left parts. Normally, in
Excel, I would use the Find(), Len(), Right() and Left() functions to
do this, but there doesn't seem to be a Find() function in Access.

Does anyone have any advice?

E-mails would be greatly appreciated.

Thanks in advance.

Angela
 
I am trying to do something in Access that I'm used to doing in Excel.

I'm building an expression in a query. I want to separate a string
containing a hyphen into its right and left parts. Normally, in
Excel, I would use the Find(), Len(), Right() and Left() functions to
do this, but there doesn't seem to be a Find() function in Access.

Does anyone have any advice?

E-mails would be greatly appreciated.

Thanks in advance.

Angela
Click to expand...

I don't know what the Excel Find() function is, but I suspect it's
equivalent to the InStr() function.
 
I don't know what the Excel Find() function is, but I suspect it's
equivalent to the InStr() function.
Click to expand...

From what I understood the InStr() function returns True or False.
The Find() function returns a number indicating the position in the
string where the look-up value is found.

If I'm wrong, please let me know.

Thanks.
 
From what I understood the InStr() function returns True or False.
The Find() function returns a number indicating the position in the
string where the look-up value is found.

If I'm wrong, please let me know.
Click to expand...

Okay. You're wrong! :-) InStr() returns the position of the string
sought within the string searched. See the online help (in the VB
Editor environment) for details.
 
Back
Top