List of Dates

[Maggie]

I need to make a list of dates from the following:


Field Example

RptStartDate 1/13/06

RptQty 10

RptInterval 5


Do I need more information to work with.


My list should display the dates for the next reports due. Like a payment
table on a loan.


Example Report result:


Report A

Start Date:1/13/06

Reports Due: 10

Yealy Interval: 5


Report Schedule:

1. 1/13/2006

2. 1/13/2011

3. 1/13/2016

4. 1/13/2021

5. 1/13/2026

6. 1/13/2031

7. 1/13/2036

8. 1/13/2041

9. 1/13/2046

10.1/13/2051


End of Report


I am using the DateAdd and DateSerial Functions in the details portion of
the report. They do not give me a "list". The functions use the start date
and the interval just fine, but they do not let me tell it how many times to
do it.


It needs to loop. Is this possible without getting too complicated?

 

[Duane Hookom]

Allen Browne answered your same question in another NG where you asked the
same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)