J
Jan @ Family Service Lincoln
In Access 2003 trying to write a report that will show the amount that is
owed through a certain payperiod. This is to track what is owed for United
Way. The total donation is split into 26 payments for each payperiod. If
they are termed, we are no longer responsible for their portion of the
donation, need to calculate what is owed based on term date.
I have never been good at writing formulas outside of the standard ones.
I assume that I will need to use a lookup table for dates and number of
payperiod, but have no idea how to do this.
owed through a certain payperiod. This is to track what is owed for United
Way. The total donation is split into 26 payments for each payperiod. If
they are termed, we are no longer responsible for their portion of the
donation, need to calculate what is owed based on term date.
I have never been good at writing formulas outside of the standard ones.
I assume that I will need to use a lookup table for dates and number of
payperiod, but have no idea how to do this.