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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memo fields not displaying in query 4
Dates in a memo field 3
Query field size quandry 2
Memo fields in a query 4
disctinct query memo field 3
how can I specify text criteria when querying a memo field 1
Make Table Query Truncating Memo Field at 255 Characters 2
Query with memo field shows only two chinese charcters when linked 3

Back
Top