Hello, everyone!

My problem is based in a row obtained in a query as in the following example:

Cost NumberOfInstallments First Payment Last Payment
 120 6 1-Jan-05 1-Jun-05

(All these where properly given or calculated.)

What I need to do? Dividing 120 by 6, I need to create a table
with the following fields/rows:

Cost Date
20 1-Jan-05
20 1-Feb-05
20 1-Mar-05
20 1-Apr-05
20 1-May-05
20 1-Jun-05

In other words, when a payment is known to be accrued and the number of installments is given (1=only one payment, at the date given) , I need to create a table with all first days of successive months till the last payment and at each date the same value to be considered charged. (If you pay annually for a magazine, I want to consider it paid month by month, ok?!)

How should I proceed?

Thanks a lot,
fskilnik