Auto-fill with a date

[rmoore]

Trying to auto-fill payment dates based on start date and the number of payments. Field1 is the start date, Field2 is the days between payments, Field3 is the number of payments. i need Fields 4 thru Fields 15 to auto-fill with how many dates in Field3.

[Bob Fitz]

It sounds to me as though your db is not properly normalized.

i need Fields 4 thru Fields 15 to auto-fill....

This allows for up to 11 entries but what if the requirement changes to something greater.
I would recommend that you normalize your data.

[Bulzie]

I'd agree with Bob on the normalization. To kinda answer your question and play with the logic some, you could maybeuse DateAdd function, something like:

Field2 is length of days to add
Field3 is total number of payments or total fields to populate

vDate = StartDate
y = 4

For x = 1 to Field3

Field(y) = DateAdd("d", Field2, vDate)
y = y + 1
vDate = DateAdd("d",Field2, vDate)

next x

Like Bob said though, if you had more payments then fields you would have an issue.

[rmoore]

Thanks for the advice. Im not sure what you mean the DB is not normalized.

[Bob Fitz]

I would recommend that you search this forum and/or Google and read up a little on the subject. Working with a Db that is not normalized is likely to cause you problems.