How do I make an "X" in one field be a number in a calculation in another field?

[Guest]

[try67]

Some say a picture is worth a thousand words, but this is not the case, I'm afraid...

Please describe what exactly you want to achieve.

[Guest]

When I type an X in a box I want the X to equal a number in the "Total Fees to Dept of State" column. So - if I type an X in the "Minor Fee $80" box I want it to show up in the "Total Fees" column as $80. Like it does in the example. Likewise, if I type an X in any box in the row that has a correlating amount (i.e. $110, $15) I want the "Total Fees" to reflect the addition of those amounts. $110+20.66+60=$184.85. Basically sum the Xs across the row that have a correlating fee. I did have a form that did that, but it is locked and no one knows the password. The form has been modified in some respects so I had to redo it all and now am stuck. Thanks for your response.

[try67 · Accepted solution]

Set the "Export value" of the check-box to 80 and use it in your calculation, just like a text field.

[Guest]

Thank you!!