Built-in FIND() function in Access?

[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

 

[Dirk Goldgar]

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 don't know what the Excel Find() function is, but I suspect it's
equivalent to the InStr() function.

 

[angelasg]

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

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.

 

[Dirk Goldgar]

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.

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.

 

[angelasg]

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks!