MS ACCESS- how to do

[Elaine]

This is an example of what I need to do:

Data in an ACCESS table:

CustomerID: AAA
Pay_Month: Dec-2006
Type:General
Adjust_FromDate:N/a (for general payments, no adjustments)
Adjust_EndDate: N/a
Amount: 100
Months:n/a
Ratio:n/a

CustomerID: AAA
Pay_Month:Jan-2007
Type: Adjustment
Adjust_FromDate:12/1/2007
Adjust_EndDate:12/31/2007
Amount:100
Months:1 (number of months of adjustment period)
Ratio: 100/1=100 (amount/months)

CustomerID:AAA
Pay_Month:March-2007
Type:Adjustment
Adjust_FromDate:12/1/2007
Adjust_EndDate:2/28/2007
Amount:300
Months:3
Ratio:100

Now, I need that the amount of adjustments be applied to the corresponding
month. This is the output I need to get.

CustomeriD:AAA
Pay Month: Jan-2007
General Payment:0
Ajustment Payment:100 (Adjustment reported on march)

Pay month:Feb-2007
General Payment:0
Adjustment Payment:100

In case that a general lpayment be done in a particular month, the program
needs to be able to sum the tow amounts to obtain a total amount (general +
adjustment)

 

[Gordon]

This is an example of what I need to do:

I think you'll get a better and quicker answer posting in a dedicated Access
group....