Create a field from another field

[vavs]

I have a field in a table that I link to a Lotus Notes database. The field is formatted Name/Location/CostCenter/Business Unit.

What I want is just the Name portion of the field. In Excel I can do a formula =Left(Cell((find("/",Cell,1)-1))) and get what I need. I just do not have a clue as to how to do the same thing in Access. Also, I cannot add a field to a linked table, so I will have to do a make table or append table query. I am not sure whether this is an advantage or not.

 

[CT Witter]

Try

Left(Cell, InStr(Cell, "/") - 1)

HTH,
CT

 

[giacomo]

looks like maybe you answered the question I had for you on the other thread (http://www.mrexcel.com/board2/viewtopic.php?t=287751)

you can break it out in a query using the following expression:

Left([some_field],InStr([some_field],"/")-1)

whether you want to make a new table or just reference the query in your subsequent queries is up to you. I personally am not a big fan of queries on top of queries though.

hth,
Giacomo