# Summary-Crystal Quote Form

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-02-07 10:40 UTC
**Views:** 437
**Replies:** 0
**URL:** https://www.epiusers.help/t/summary-crystal-quote-form/2173

---

## Post #1 by @system

<div id="ygrps-yiv-416106980">Thanks to Jim Stetter and Jim Dorsey for pointing me in the right direction.<br/>
Jim Stetter recommended creating a formula to trim the QTYNUM string field<br/>
to make certain that the field was being entered properly and Jim Dorsey<br/>
recommended browsing the string field in the formula editor and the PASTE<br/>
the data to be sure I have the format correct in the formula. I first tried<br/>
The formula with trim function it still did not work. I then went to browse<br/>
the data and noticed the data was 4, 5, 6, 7 and my formula was looking at<br/>
1,2,3,4,5. Once I changed the string values in the formula it worked.<br/>
<br/>
I still do not understand why the string values in the QTYNUM field are<br/>
starting at the number 4 and I am a little concerned that these will change<br/>
and screw up the formula.<br/>
<br/>
Thanks<br/>
Todd Hofert<br/>
Spartan Graphics, Inc.<br/>
(616)887-8243</div>

---


**Canonical:** https://www.epiusers.help/t/summary-crystal-quote-form/2173
**Original content:** https://www.epiusers.help/t/summary-crystal-quote-form/2173