Query size of memo field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to query a memo field to find out which record in the database
contains the most text in the memo field?

TIA
 
Janna,

Add into a query based on your table containing the memo field
"MemoLength:len([memo field name])" without the quotes. Sort this column
descending and the first record you see should be the longest memo field.

HTH

Terry
 
Back
Top