I would like to break the Name Field in my Access Database in the Format Last Name, First Name Middle Name into the Last Name Only.
I can do this in Microsoft Excel using the Left Function. Is there any comparable function I can use in a Query or Form to break out the Last Name.
I do not know how to use Visual Basic.
Thanks for your help.