Recent content by Lasitha_kamalpriya

The way I ask this question is so stupid. I'm very sorry for the disturbances. I just prepared this on a excel sheet. I have to create a access database then I'll back with the problem. sorry again:banghead::banghead:

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. :)

I could get your instance from this page Ken's Sample Databases thanks Mr.Hartman

but can It apply to table?

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