Sort text field by 2nd word

[JWeaver]

I have a text field that contains names of workers in FName LName format. Is
there a way that I can sort this field by the Last Name (2nd word of field)
so that the records will be in alphabetical order by last name instead of by
first name? I know that the best way would be if the names were in separate
fields but this is how the database was set up some time ago.

Thanks!

 

[Duane Hookom]

You can use an expression in the Sorting and Grouping like:
=Mid([FieldName], Instr([FieldName]," ")+1)

 

[JWeaver]

Thank you. That worked beautifully!!
--
JWeaver

You can use an expression in the Sorting and Grouping like:
=Mid([FieldName], Instr([FieldName]," ")+1)

--
Duane Hookom
Microsoft Access MVP

I have a text field that contains names of workers in FName LName format. Is
there a way that I can sort this field by the Last Name (2nd word of field)
so that the records will be in alphabetical order by last name instead of by
first name? I know that the best way would be if the names were in separate
fields but this is how the database was set up some time ago.

Thanks!