Count the number of charaters in a string

J

Jenn

is there a way to count the number of characters in a string of "Field A" and
put that counted number in "Field B"?
here is an example: Field A = CAT, Field B = 3
Thanks in advance!
 
J

John Vinson

is there a way to count the number of characters in a string of "Field A" and
put that counted number in "Field B"?
here is an example: Field A = CAT, Field B = 3
Thanks in advance!
Click to expand...

FieldB should NOT be stored in any table. It's redundant.

Instead, create a Query and type

FieldB: Len([FieldA])

in a vacant Field cell.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
J

Jenn

Thank you!

John Vinson said:
is there a way to count the number of characters in a string of "Field A" and
put that counted number in "Field B"?
here is an example: Field A = CAT, Field B = 3
Thanks in advance!
Click to expand...

FieldB should NOT be stored in any table. It's redundant.

Instead, create a Query and type

FieldB: Len([FieldA])

in a vacant Field cell.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Top