counting characters in a column?

  • Thread starter Thread starter scott
  • Start date Start date
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
 
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,
 
Back
Top