Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Thanked 0 Times in 0 Posts

    Name sort in a table (Access XP)

    I have a two separate fields in a table, one for Last Name and one for First Name. I want an additional field for Name Sort that would be filled in automatically with the Last Name and First Name from the respective fields. How do I do this? Thank you.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Name sort in a table (Access XP)

    You can do this in a query: create a query based on the table, add the fields you need, and enter the following in the first empty column:

    Name Sort: [Last Name] & ", " & [First Name]

    You can use this query as basis for forms and reports (and for other queries, if necessary).

    You shouldn't store the Name Sort field in the table itself:
    - It is redundant information.
    - You'd run the risk that it is not kept up-to-date if a first or last name is edited.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts