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. comdisco

    Rolling total formula

    Thanks for all your suggestions. I have followed Madawc's advice but when I run the report I am getting Bad Date format string on the Param_Date formula field. Is it because the period field that I am trying to set to Date is held as a string in the database???
  2. comdisco

    Rolling total formula

    Anyone please????????
  3. comdisco

    Rolling total formula

    Please ignore this as I made an obvious mistake, have added another thread....
  4. comdisco

    Rolling total formula

    Can anyone tell me the syntax to calculate the last 12 months rolling total. The report parameters are period e.g. 01, 02, 03 etc and a year parameter. If the user selects period 06 in 2003 then I want the total to be for the last 12 periods e.g. period 06 - 12 in 2002 and periods 01 - 06 in...
  5. comdisco

    Rolling total formula

    Can anyone tell me the syntax to calculate the last 12 months rolling total. The report parameters are period e.g. 01, 02, 03 etc and a year parameter. If the user selects period 06 in 2003 then I want the total to be for the last 12 periods e.g. period 01 - 06 in 2002 and periods 01 - 06 in...

Part and Inventory Search

Back
Top