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 Chris Miller 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. cengleman82

    Find the difference between 2 rows in grouped data that is restrained by time

    I got it. It was telling me exactly what was wrong, but I guess I'm kind of dense. I revised the avgmpg statement to read as follows: numbervar avgmpg; numbervar milesum; numbervar fueltot; whileprintingrecords; if fueltot > 0 then ( avgmpg := milesum/fueltot ) else ( avgmpg := 0 ) We have...
  2. cengleman82

    Find the difference between 2 rows in grouped data that is restrained by time

    No. I have the accumulator in the details. The error kicks back to the avgmpg formula. It is the only one that won't work with the details hidden. I placed it in the vehicle # group footer. I even recreated the entire report from scratch to make sure that there wasn't something left over from my...
  3. cengleman82

    Find the difference between 2 rows in grouped data that is restrained by time

    I'm glad my wife doesn't like those shows, but I admire your methods to get out of watching. I can't thank you enough for what you've done so far. I'm going to tell everyone I couldn't have done it without CoSpringsGuy, but most likely I'll get all the glory. Anyway, everything works except...
  4. cengleman82

    Find the difference between 2 rows in grouped data that is restrained by time

    So one more caveat. Any ideas how to total this new "difference" column? I've read and tested some 3 part variables with no luck. I don't know if it is because of the suppression techniques involved or not. I really just need to find the differences between the odometer readings, total them, and...
  5. cengleman82

    Find the difference between 2 rows in grouped data that is restrained by time

    CoSpringsGuy, Thank you! That works well. I do have the vehicles grouped, but I tested it out and it works fine for all of them. I knew there had to be some way of having it pull most all of the data, but not displaying all of the data, I just couldn't put my finger on it until you mentioned...
  6. cengleman82

    Find the difference between 2 rows in grouped data that is restrained by time

    I'm trying to figure out a formula that will assist with a fleet gas report. The report displays data as follows: Vehicle #|Date of Fillup|Amt of Fuel|Odometer at fillup|Difference|MPG 1 |12/31/12| 10.00 | 30,000 | __ | 50 1 | 1/1/13 |...

Part and Inventory Search

Back
Top