Iterate Report by MONTH between 2 dates

[esipp]

I have been struggling and researching for an answer to this problem for so so long! What I am trying to do is have a table for a charge to a customer, have a start and end date for this specific charge, and have the report make an invoice (or repeat the detail) for EACH MONTH between these dates (sort of trigger dates for a charge increase).

For example:

Cust ID:Quaker Boats
Start Date: 1/1/04
End Date: 3/1/04
Charge: $50

Report

Invoice 1:
Quaker Boats: January Charges
$50

Invoice 2:
Quaker Oats: February Charges
$50

Invoice 3:
Quaker Oats: March Charges
$50

Right now, the only way I can get this to work is to have a separate record for each month (but when a charge can last for over a year (12 identical records/year/customer) this gets cumbersome and inefficient VERY FAST.

Please HELP!

 

[MStef]

Hello Esipp!
Look at "DemoIterateReportA97.mdb".
I think I guess what you want.
Adapt it how you need.

 

[esipp]

Thank you for your reply. I think this may have the answer I'm looking for, but HOW does the "Unbound" field under the Anum header get populated?

 

[MStef]

Hello esipp!
For populate "Unbound" field in "Anum header"
look at VBA (Report1) Sub GooupHeader0_Format,
and stretch it for the other month.