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!

Recent content by ZZaletel

  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...
See more

Part and Inventory Search

Back
Top