Count the number of charaters in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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...
 
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

counting Charaters 1
How to Populate Data from a table to another 0
Pulling the town out of an address 5
Counting specific characters within a field 5
Generate string from selected checkboxes on continuous form 3
Calculating a ratio based on letters in a field 5
How to subtract a number from a Mergefield? 0
Access Dcount (multiple criteria) 3

Back
Top