Calculate the duration specific value continue from

[Lasitha]

Please let me know how to get the "Debts Continue from" value in a Access Query
I only need to get the answer the name of the month or count of Months Debts finally continue from.

Supplier No	Name	April	May	June	July	Debts Continue from
1	Alan	-50	0	0	-1000	July or 1
2	John	-100	-105	-115	-120	April or 4
3	Perera	-15	0	-20	-25	June or 2

[burrina]

What do you mean by Continue from? Are these dates hard coded? Do you want to get the Debts from a certain date or month? Please explain better.

[June7]

You want to know the first month with amount less than 0 following a month that is 0?

This is not a normalized data structure. Does your table actually have a field for each month? If so, then this will need a custom VBA function or a series of queries. The first query would be UNION to rearrange the data into normalized structure.

[Lasitha]

What do you mean by Continue from? Are these dates hard coded? Do you want to get the Debts from a certain date or month? Please explain better.

Thanks burrina,
This is just a query, In this query debts have mentioned under each month for each suppliers.
As the 3rd instance Suppplier No 3, his debts is over(he settle his debts amount) on May and again started on June. now he continue his debts amount for 2 months (June & July). So I need to get result as "2"

I query this chart from another related tables. Primary key is Supplier number.

[Lasitha]

You want to know the first month with amount less than 0 following a month that is 0?

This is not a normalized data structure. Does your table actually have a field for each month? If so, then this will need a custom VBA function or a series of queries. The first query would be UNION to rearrange the data into normalized structure.

Dear June7
I'm very beginner to access. Normalizing and analyzing are not much familiar to me. If u feel free please direct me to good web site where I can study Database programming with access from beginning & sorry for disturbances.

In this case, I query this from another related tables with primary key of "Suppler No."
In this query Debts amount has mentioned under each month. If there is a "0" value mean that the supplier has settled the debts amount. Actually my boss ask me to find the duration the debts continue.

As the 3rd sample (Supplier No 3) he settled to debts on Month of May. But again start on June and continue it to present. So I need to count that duration in "Debts continue from" column. Thank you

[June7]

Lots of tutorials on web and lots of books. But start with http://www.rogersaccesslibrary.com/

If what you posted is the result of a query, then show sample of raw data.