Search results

I need to count all values after "0" or null value of a rows in query of a table. I have attach Table.gif Actually in need to get the duration of debts continue of a supplier as following sample. Highly appreciate your cooperation. :)

METHOD TABLE ======= CTC ORT --------------------------- TEA GRADES TABLE ================ METHOD TEA_GRADES CTC BP1 CTC PF1 CTC D CTC D1 ORT BOP ORT FF ORT OPA ORT...