Distributing payments each month.

[Rita Starich]

I am converting a Paradox program (not created by me)to
Access. This database is for Access97. In Paradox the
payment is put in and then a distribution report is run
and the payments are automatically distributed based on
monthly amount. Is this possible to do in Access?

 

[John Vinson]

I am converting a Paradox program (not created by me)to
Access. This database is for Access97. In Paradox the
payment is put in and then a distribution report is run
and the payments are automatically distributed based on
monthly amount. Is this possible to do in Access?

Yes.

I certainly couldn't begin to tell you how, not knowing anything about
the table structure or what the logic of the distribution might be,
but Access is perfectly capable of doing this, either with a Query, or
with VBA code, or perhaps both.