Is there a find function for Access

[Ajayi32]

One of the fields in my table stores information like this:

Northern Inbound
Northern Outbound
Northern Customer Relations
West Retention
West National Accounts
Southern Retention
Southern Billing

These are divisions and groups. I want to drop the Northern, West (divisions) and only display Inbound, Outbound, (groups).

In excel I am able to do this using the following function:
=Mid(C2,Find(" ",C2),20)

There does not appear to be a "find" function in Access. Do I need to create a custom function (if so how would I write it) or is there some other way to accomplish this.

Thanks,

/uh

 

[dcx693]

To find a string within another, you can use the Instr() function.

 

[Ajayi32]

To find a string within another, you can use the Instr() function.

Thank you...it works

/uh

 

[Pat Hartman]

You would be better off if you normalized your table. Division and Group should be in separate fields rather than mushed together.