Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting memo field (2000)

    Is there any way to sort the records in a database by the first word in a memo field alphabetically?
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting memo field (2000)

    You can create a query on the table (I assume that you meant table instead of database), and add a calculated column

    IIf(InStr([MemoField]," "),Left([Memofield],InStr([MemoField]," ")-1),[MemoField])

    where MemoField is the name of your memo field. Clear the Show check box for this column and set the Sort order to Ascending.

Posting Permissions

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