2 Replies Latest reply on Apr 8, 2013 2:29 PM by fmkelly

# How Do I Count the Number of Integers in a Field?

### Title

How Do I Count the Number of Integers in a Field?

### Post

I'm creating a production form for screen printing team shirts.  Below is a screen shot of part of the form.  At the bottom of the form (not shown here) there is a summary total for each size so we can order shirts by team.  In the example below, all players get a XXL shirt.   You'll see on the far right, a column of numbers under the # symbol.  These are the numbers that will be printed on the back of each player's shirt.  Nat gets a "25", Tim a "24", Bobby a "2' and John wants a "6".  Four players for a total of 6 digits...2...5...2...4...2...6.  We price \$1.55 per digit.  If I can summarize the total number of digits to be applied, in this case, 6, I can then multiply that by \$1.55 to get a total for applying numbers.  It would sure make biling quicker!

How do I create a summary field that tallies the total of digits in the # column.  Your thoughts?

(Note: In this example, each player is their own 'record'. You are seeing the form as a list.)

• ###### 1. Re: How Do I Count the Number of Integers in a Field?

Define a calclulation field that uses the Length function to count the number of characters in the # field. Set up a summary field to compute the total of the calculation field.

• ###### 2. Re: How Do I Count the Number of Integers in a Field?

Got it, Phil.  Thanks!  Now, that I got it to work across multiple records, I've decided my production sheet would make more sense as a form.  Your suggestion will help a lot.  Thanks again.  Kelly