I need a query to breakdown this name..
Dietz C. (AP) [C] to Dietz C
O'Brien N. NEW [C] to O'Brien N
Brown Matt Office [C] to Brown M
I need a query to breakdown this name..
Dietz C. (AP) [C] to Dietz C
O'Brien N. NEW [C] to O'Brien N
Brown Matt Office [C] to Brown M
Try this query:
Change "NameTest" to your table name and "Fullname" to your field name.Code:SELECT NameTest.Fullname, Left([fullname],InStr(1,[fullname]," ")+1) AS Expr1 FROM NameTest;
Fullname (Input)
Expr1 (Output)
Dietz C. (AP) [C] Dietz C O'Brien N. NEW [C] O'Brien N Brown Matt Office [C] Brown M #Error
Thanks ssanfu, it worked perfectly. I got confused and created the left and right function in one query and was giving me issues.
[/QUOTE]
Fullname (Input)
Expr1 (Output)
Dietz C. (AP) [C] Dietz C O'Brien N. NEW [C] O'Brien N Brown Matt Office [C] Brown M #Error
Happy to help...