Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    8

    Unanswered: Sorting Question

    I have setup a database with names, classes and dates. I have entered the name as one field i.e. "Joe Smith"

    Is there a way to sort by the last name without splitting the name field into a first name and a last name?

    Right now it sorts by first name.

    Your help would be appreciated.

    Thank you in advance.
    Sandy

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    One of the rules of database design is to break fields down into their most basic groups. Therefore, you should consider breaking the field into two fields, first name and last name. Then you can join these fields when you need to for their full name, and you can sort by first or last name.

    So, exampli gratia, have one field with "Joe" and one with "Smith".
    Me.Geek = True

Posting Permissions

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