payments dates by number of payments

[Ken]

I am trying to set up installment coupons, I need them to print by date due
times the number of payments.

Thanks

 

[Duane Hookom]

Do you have any additional information? I assume you want to create a
report. Reports are generally based on a record source of a table or query.
Can you provide some structure information as well as sample records?

 

[Ken]

Yes I would like to set up a report that replicates payment coupons, (i.e. 5
payments= 5 coupons with consecutive due dates 12/1/05;1/01/06...)I have a
table set up with id number, name installment amount, due date and number of
payments.
Thanks

 

[Duane Hookom]

First create a table of numbers (tblNums) with a single numeric field (Num)
and add records 1 through your maximum number of payments. Create a report
for your coupons based on your "table set up" and tblNums. Don't create any
join line.

Add the Num field to your query grid and set the criteria under it to:
<=[Number of Payments]
Add another field in the query like:
PaymentDate: DateAdd("m",[num], [due date])

This will duplicate the record in your report to equal the number of
payments.

 

[Ken]

That worked great. Thanks for your help.

First create a table of numbers (tblNums) with a single numeric field (Num)
and add records 1 through your maximum number of payments. Create a report
for your coupons based on your "table set up" and tblNums. Don't create any
join line.

Add the Num field to your query grid and set the criteria under it to:
<=[Number of Payments]
Add another field in the query like:
PaymentDate: DateAdd("m",[num], [due date])

This will duplicate the record in your report to equal the number of
payments.

--
Duane Hookom
MS Access MVP
--

Yes I would like to set up a report that replicates payment coupons, (i.e.
5
payments= 5 coupons with consecutive due dates 12/1/05;1/01/06...)I have a
table set up with id number, name installment amount, due date and number
of
payments.
Thanks