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