How to count the last values which are not null

[Lasitha_kamalpriya]

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.

 

[GinaWhipp]

I'm thinking by the lack of answers people are as confused as I am...

It's not *normal* to get the Count of NULL or zero(0) in a Row(record). It would make more sense to do in a Column(field). Having it in a Row (record) suggest that perhaps your Table is set up more like an Excel Spreadsheet than an Access Table.

So, is your Table set up as we see it in your image? Or are we looking at a Crosstab query?

 

[Lasitha_kamalpriya]

I'm thinking by the lack of answers people are as confused as I am...

It's not *normal* to get the Count of NULL or zero(0) in a Row(record). It would make more sense to do in a Column(field). Having it in a Row (record) suggest that perhaps your Table is set up more like an Excel Spreadsheet than an Access Table.

So, is your Table set up as we see it in your image? Or are we looking at a Crosstab query?

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:

 

[GinaWhipp]

Heh, no problem at all that is why we are here, to answer questions!