Rearrange name in Table

[Brian62]

I have a table that the names were entered by First name and Last name. I would like the names to be by last name, frist name. I already have a query that is setup to pull and entered by last name, first name. The information is old so I have to be able to change the table data. All new names will be entered by Last, first.



Is there a way to do this?

[RuralGuy]

They should really be in two different fields. Have you considered that yet?

[Brian62]

I figured out a fix. Thanks!

[RuralGuy]

That's great. Care to share what you learned with others on this site?

[Brian62]

What I did was create a filter to select from any part of the name (first or last) (Like "*" & [Enter Name: First or Last] & "*") to pull the name of my choosing. When the new name format is entered in it won't give me problems since the data will be filtered by a between date so the new name format will eventually take over. I will be filtering by the previous quarter.

[RuralGuy]

Thanks for sharing!