Is there a way to find the date where a client's balance becomes morethan zero?

[Ron]

Hi All,

I have a table that contains clients, another that contains
transactions. Linked by clientID. Within the transaction table,
amoung many other fields, there's a DateOfTrans field and an
AmountOfTrans and Quantity fields that are multiplied together to
provide the total for that particular item. There could be many items
purchased on that day. Plus a payment can be input into this same
transaction table and is just a negative number.

So, let's say that Clark Kent comes in and purchases stuff on April
10th, again on April 13th and then again on April 19th. Our agreement
with superma.... ahhh... Clark is that we don't want the payment for
what he buys till his client pays him. Over the next couple months,
Clark pays for the April 10th and the 19th stuff, but still owes for
the 13th. So, it's now June 11th and I want to know what date is the
first date in the file where Clark still owes us money.

I don't want to run a report and have all the transactions listed out
with totals by date to get this info (I already have one), I just
want to click a button and have that date appear. Possible? How?

Thanks,
ron

 

[KARL DEWEY]

You omitted some stuff - where/what field is the payments recorded?
Your fields --
Item - I assume this field exist
DateOfTrans
AmountOfTrans
Quantity
How is a payment a negative number?

Do you have a field for date of payment?