payment schedule report

[nims2k1]

Hello All
I need to create a report using access for a repayment schedule. I have a table that holds the input field of number of payments but when I print the report I need to print each payment number and the related payment amounts.
ex:If number of payments is 3 then report shoul show
payment num payment amt
1 100
2 98
3 95
and so on.Do I need an array to to do this as the field on the table only holds the total number of payments as of now.How do I show the breakdown??

-N

 

[JonFer]

If you want to create multiple records from one record, you'll need another table with as many rows as the highest number of payments. It just needs one column that is an integer - fill out the rows with the numbers 1 on up. Bring this "Sequence" table into a query with your payments table and add this criteria:

SequenceNumber <= NumberOfPayments

 

[Aubs010]

I assume your table has a field called something like "PaymentAmount"

If so, create a report
on it, create a field that links to the table and PaymentAmount

so your report looks like this:
[tt]
_______________
| Amount | <-- Page header
| 100 | <-- Number from PaymentAmount field
| 50 |
| 10 |
| 150 |
| |
|_______________|
[/tt]

Then, create

a TextBox on the form, next to the amounts.

Press F4 to show the properties dialog.

In the ControlSource for the TextBox, type: =1

set the "Running Sum" option to: Over Group

[tt]
_______________
| Number Amount | <-- Page header
| 1 100 | <-- Number from PaymentAmount field
| 2 50 |
| 3 10 |
| 4 150 |
| |
|_______________|
[/tt]


There you go!

Hope it helps

Aubs