Delimiter condition

[helpmeimpoor]

So I created this delimiter:

Left([tablename],InStr(tablename),".")-1)



So if i have a name like mike .123, it will return me mike. The problem is, some names are "george" without any dot after and it returns func! error for these names.

How can i set a condition so that above applies only when there exists a dot

[accesstos]

As below:

Left([tablename], InStr(1, [tablename], ".") - IIf(InStr(1, [tablename], ".") = 0, -Len([tablename]), 1))

[isladogs]

Or Split(tablename,".")(0)
For example

?split("mike .123",".")(0)
mike
?split("george smith",".")(0)
george smith

[helpmeimpoor]

Or Split(tablename,".")(0)
For example

?split("mike .123",".")(0)
mike
?split("george smith",".")(0)
george smith

HI

sorry to bother you. So basically I want the dot removed and then i am running a relationship.

Now in my other database, the names are all correct, without dots.

In access, when I link the 2 databases together, the relationship only compares the name if the two did not have dots. For example, Mike .123 will not match with Mike in another database. But Mike will match with Mike in other database.

[helpmeimpoor]

Or Split(tablename,".")(0)
For example

?split("mike .123",".")(0)
mike
?split("george smith",".")(0)
george smith

please see attached picture. notice how where .rc. or other stuff, it doesnt look at relationship.



UPDATEEEEEE:

One solution I see if creating a new query where I am linking the edited query with the driver name, no issue then. But if its possible to work within existing query, it will be better i assume

[isladogs]

Sorry but I don't really understand your replies.
You can use the expression as a new field in a query to join onto another table or query.
However the Split function doesn't work in queries. Use the other approach