Sort according to field length?

[wawinc]

Is there a way to sort according to field length or number of characters in a note/memo field?

I'm hoping to sort descending so the longest memos appear first...

[William McKinley]

Try this:

SELECT Table.YourField, 
FROM Table
ORDER BY Len(YourField) DESC;

[ConneXionLost]

add a calculated field to the query that counts the number of characters, like:

fieldlength: Len([yourfield])

then sort on that field.

[wawinc]

Try this:

SELECT Table.YourField, 
FROM Table
ORDER BY Len(YourField) DESC;

Perhaps I am too much of a newbie to be in this forum. How do I use code?

My best guess'd be:
Database Tools> Visual Basic> File> New?

Saving it, applying it, and deleting it if it doesnt work - all easy/intuitive, I presume?

If there is some sort of How to on this stuff I'm happy to do it...

Thanks!

[William McKinley]

This would be achieved by using a query. Here's an article that explains the basics of queries: http://office.microsoft.com/en-us/ac...010209892.aspx

Create Tab on the Ribbon > Query Design, don't add any tables > Click SQL View > Paste the code below with your field names > Run

SELECT YourFieldNameHere
FROM YourTableNameHere
ORDER BY Len(YourFieldNameHere) DESC