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!

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

Recent content by zidol

  1. zidol

    Maximizing a total at 24

    Thank you for your help!
  2. zidol

    Maximizing a total at 24

    Formula: {Hours 1} - {Hours 2} = 28 hours I want it to return the total, but maximize at 24 How do I write the formula for this?
  3. zidol

    Display Second Fastest Truck

    Good morning - I finally got to try the formula and it does work great. How can I find out what the 3rd fastest truck?
  4. zidol

    Display Second Fastest Truck

    I have not tried it - I am having problems with connection to my database. Hopefully I can tomorrow. Question - what if I want to know the 3rd fastest?
  5. zidol

    Display Second Fastest Truck

    Hi Pete - I am trying to get the 2nd fastest truck. I think what you described would give me the 1st truck. Thanks - Lynn
  6. zidol

    Display Second Fastest Truck

    My data consist of records with Incident Numbers. Within these incident records are several trucks with a response time attached to each truck: Incident Number - 160039 Truck - E34 ____ Response - 2.85 Truck - E35 ____ Response - 2.83 Truck - T34 ____ Response - 6.30 Truck - A35 ____...
  7. zidol

    How to change the start page number in crystal?

    I want to start the first page of my report at page number 5 and the following pages to increase by one. How do I do this? Thanks for your help.
  8. zidol

    Adding a decimal point to a number

    Yes - I do. I meant to type 1.5 - but thanks!
  9. zidol

    Adding a decimal point to a number

    Great! That worked. Thanks for your help.
  10. zidol

    Adding a decimal point to a number

    I have two fields: {Coverage.TOTALHOURS} which displays as "1.00" {Coverage.TOTALMINUTES} which displays as "30" - No decimal point Formula is: {Coverage.TOTALHOURS} + {Coverage.TOTALMINUTES} Because the {Coverage.TOTALMINUTES} does not have a decimal point, it returns "31.00" - I need it...
  11. zidol

    Trying to sum a text field that has been converted to a number

    No I do not have null values.
  12. zidol

    Trying to sum a text field that has been converted to a number

    That worked! Thanks so much!
  13. zidol

    Trying to sum a text field that has been converted to a number

    I have a text field that I converted to a number. I am not able to get a sum of the new number field. The I have tried the following formulas. Formula Name: NumPerson1 Formula: ToNumber({IncdApps.NUMBEROFPEOPLE}) I place this formula in the report and the field shows up as a number. I insert...
  14. zidol

    "Countif" with a Condition Question

    It Works! Thanks for all your help!!
  15. zidol

    "Countif" with a Condition Question

    Wow - that is great. Thanks!!
See more

Part and Inventory Search

Back
Top