Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

Sorting memo fields or fields that reference a memo field

Last updated: 10 Nov 2002

Keith Seeley writes: Approach is resistant to sorting any field that is a memo field or references a memo field. However, there is one way to get the first 23 characters into a calculated field that can be sorted (more than 23 if you want to add additional calculated fields).

You need to convince Approach that it's not dealing with a memo field by converting each of the first 23 characters in the memo field to it's ASCII value, then converting it back to a character and combining as you go along.

Define two calc fields, SortableMemo and SM, and sort on SortableMemo. All you need to do is simply change "YourMemoFieldHere" in the SM formula to the name of your memo field.


SM = Left(YourMemoFieldHere, 23)

SortableMemo =
Combine(Chr(Asc(Middle(SM, 1, 1))), Chr(Asc(Middle(SM, 2, 1))), Chr(Asc(Middle(SM, 3, 1))), Chr(Asc(Middle(SM, 4, 1))), Chr(Asc(Middle(SM, 5, 1))), Chr(Asc(Middle(SM, 6, 1))), Chr(Asc(Middle(SM, 7, 1))), Chr(Asc(Middle(SM, 8, 1))), Chr(Asc(Middle(SM, 9, 1))), Chr(Asc(Middle(SM, 10, 1))), Chr(Asc(Middle(SM, 11, 1))), Chr(Asc(Middle(SM, 12, 1))), Chr(Asc(Middle(SM, 13, 1))), Chr(Asc(Middle(SM, 14, 1))), Chr(Asc(Middle(SM, 15, 1))), Chr(Asc(Middle(SM, 16, 1))), Chr(Asc(Middle(SM, 17, 1))), Chr(Asc(Middle(SM, 18, 1))), Chr(Asc(Middle(SM, 19, 1))), Chr(Asc(Middle(SM, 20, 1))), Chr(Asc(Middle(SM, 21, 1))), Chr(Asc(Middle(SM, 22, 1))), Chr(Asc(Middle(SM, 23, 1))))

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.