How can I split a string into 2 parts in a Microsoft Access Query
I have a field that is an email address. This address always follows the format of "firstname.lastname@example.org". The names are not always the same length. I would like the output to read "john smith". Any help with this would be appreciated!