Query size of memo field

J

Janna

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
 
T

TerryC

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
 
Top