Expression for Spliting Double Name

[CCS8DENI]

I have a feild in my query that contains both first and surnames in reverse order of a person, ie. MCMillan Andrew .

I want to add a feild in the query that contains an expression that will include the letters from the left od the feild until it reaches a space and another feild that includes letters from the right until it reaches a space, thus spliting the two names up so I can better use them in other ways.

Here's hopinfg this isn't clear as mud,

Regards

Andrew
Andrew
andrew.mcmillan@det.nsw.edu.au

Technology Adviser
Dept. of Education and Training
Deniliquin District
New South Wales
Australia

 

[sko]

First of all, you should store the first and last names in separate fields in your table. You can always concatenate them for reports/forms when necessary. That said, try this

SurName:Left([Name],InStr([name]," &quot-1)
FirstName:Right([Name],InStr([name]," &quot+1)