List of Dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maggie - 05 Jan 2006 00:24 GMT

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?

Signature

Thanks,
Maggie

Reply to this Message

Duane Hookom - 05 Jan 2006 02:46 GMT

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)

Signature

Duane Hookom
MS Access MVP
--

>I need to make a list of dates from the following:
>
[quoted text clipped - 55 lines]
>
> :)

Reply to this Message