counting characters in a column?

S

scott

I have a database of about 1000 records.

I want to count the number of characters for each record
for a certain column. I have no idea where to begin..

scott supervisor
john worker
terri lazy

It would bring back

scott 10
john 6
terri 4

Thanks
scott
 
C

Cheryl Fischer

For the calculated field which is to show the number of characters, insert
the following in the Field: row of your query:

Len(Trim(MyField))


hth,
 
Top