Prev: Creating Bank Query
Next: The best way to set up a payment schedule...PLEASE HELP!!!
From: CVBetty on 12 Mar 2010 10:55
My imported string looks like this

ACH SOC SEC 310*First Last
I want to access to find the * in the string then extract First Last
From: Jerry Whittle on 12 Mar 2010 11:15
In a query:

FirstLast: Mid([FieldName],Instr([FieldName],"*")+1)

I'd recommend this as the first step. If you want to further split first and
last, there could be problems such as names like Greg von Leghman or Mary Ann
Day.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"CVBetty" wrote:

> My imported string looks like this
>
> ACH SOC SEC 310*First Last
> I want to access to find the * in the string then extract First Last
 | 
Pages: 1
Prev: Creating Bank Query
Next: The best way to set up a payment schedule...PLEASE HELP!!!