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 Wanet Telecoms Ltd 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. ZZaletel

    Select rolling math problem

    PH, The second solution now works - and is an improvement, though still spits out incorrect numbers after about 2 years of correct answers. I've checked the table the data is being drawn from and don't see any apparent problems. Barring another solution, perhaps I just need to restrict the...
  2. ZZaletel

    Select rolling math problem

    PH - The first proposed solution breaks down in a fashion similar to the previous calculation method after about six months of data. The second proposed solution gives me an alert: "Between operator without And in query expression 't1.Date BETWEEN s1.date'"
  3. ZZaletel

    Select rolling math problem

    I'm having a problem with a database I'm using to track production numbers. I've come up with SQL code which performs the calculations, however, a spot check reveals that the code works properly for a time, and then starts returning values that are incorrect. Thus far, I've been unable to...
  4. ZZaletel

    SQL math problem

    Whoops - sorry - found my way into the incorrect forum. Apologies!
  5. ZZaletel

    SQL math problem

    I'm having a problem with a database I'm using to track production numbers. I've come up with SQL code which performs the calculations, however, a spot check reveals that the code works properly for a time, and then starts returning values that are incorrect. Thus far, I've been unable to...

Part and Inventory Search

Back
Top