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 bkrike 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 scullysiz

  1. scullysiz

    Pull Data from preivous row, same data field

    Is there any way to grab data from the previous row, same data field? For example in the data below: Vehicle Tag # Wk st dt Wk end Dt End Miles Prev End Miles abcde 5/5/11 5/11/11 10,100 abcde 5/12/11 5/18/11 10,500 10,100 Is there any way to grab the 5/5...
  2. scullysiz

    List Column Calc using row data

    I got that function to work after doing a CAST function on the data value. Thanks for the help!
  3. scullysiz

    List Column Calc using row data

    I am trying to calculate total miles for a vehicle by taking the odometer reading from the current week and subtracting the odometer from the prior week. The problem I am having is that the data is in a list report and each week is a row of data. Do you have any ideas on the best way to...

Part and Inventory Search

Back
Top