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!

Search results for query: *

  1. dartagnan3rd

    Cannot See Formula to Group By

    Thanks LB! I just needed to resolve the compile error. Turns out that the various values in my code switch between numeric and string values. I limited to just string values and it works! Next, set those numbers to strings in my SQL. Thanks again! Fred
  2. dartagnan3rd

    Cannot See Formula to Group By

    I checked and I do have a compile error. "A string is required here" is the error message and then the last "if" in the last line "else if" of my code is highlighted. What could be wrong?
  3. dartagnan3rd

    Cannot See Formula to Group By

    I need to use a formula in the Group Expert so I can change the grouping based upon a parameter yet when I go to select the formula = TOTAL_BY based on the parameter {?TOTAL_BY} with the code: if {?TOTAL_BY} = "Location" then {Command.LOCATION} else if {?TOTAL_BY} = "Dept" then {Command.DEPT}...

Part and Inventory Search

Back
Top