Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summing text fields

Status
Not open for further replies.

fender78

MIS
Aug 11, 2002
13
US
If I had time in text format, how would I go about summing these feilds?
Thanks, Jim
 
Use the ToNumber() function in a formula field to convert it to a number first, then sum the formula field. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
 
Depends upon what you mean by time in text format, I believe that I addressed this concern elsewhere.

If this is the issue of having a duration field which you converted to a text field, do the summing of the field first, and then use the previously described text formatting formula against the sum.

-k kai@informeddatadecisions.com
 
Text is more of a datatype than a format.
So, what is the data type of the field as seen by CR? faq149-732
What does the time string actually look like? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top