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 derfloh 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 harley1d

  1. harley1d

    Problem with Year to Date and Month To Date Totals

    I am having a problem with my year to date and month to date totals. What I am trying to do is calculate the totals for the YTD and MTD. I have set up a date range parameter as well allowing the user to select a beginning date and an ending date. The problem I have is in my record critera...
  2. harley1d

    Formula for Trimming numeric fields

    Using the following formula, How do I get this to only display the whole number if there is a "0" after the decimial point instead of a number? Example: if the formula return 18.5 this is ok but if it returns 18.0 I would like the 0 to be suppressed or trimmed. Sum ({@Transfer}) %...
  3. harley1d

    Help Formatting a Percent formula

    Can someone please help me with formatting this formula? The formula is working but I can't not format it to only return one decimal space. Currently it is retuning 12.54%. How do I get this to return 12.5%? I tried to convert the formula to a number to allow me to customize the number but...
See more

Part and Inventory Search

Back
Top