W wilkob Registered User. Local time Today, 01:41 Joined Jan 10, 2005 Messages 86 Feb 26, 2008 #1 I have a table with about 20.000 records. From this table I would like to "search" in a column the field that holds the text with the most characters. Is there a way to find this with a formula or expression?
I have a table with about 20.000 records. From this table I would like to "search" in a column the field that holds the text with the most characters. Is there a way to find this with a formula or expression?
RuralGuy AWF VIP Local time Yesterday, 17:41 Joined Jul 2, 2005 Messages 13,819 Feb 26, 2008 #2 Len([YourField]) will give you the count of characters in each record from which you can select the Max.
Len([YourField]) will give you the count of characters in each record from which you can select the Max.
W wilkob Registered User. Local time Today, 01:41 Joined Jan 10, 2005 Messages 86 Feb 26, 2008 #3 great !!!! This works like a charm
RuralGuy AWF VIP Local time Yesterday, 17:41 Joined Jul 2, 2005 Messages 13,819 Feb 26, 2008 #4 Excellent! Glad you got it sorted.
