Duplicating data

[dje]

I want to create a simple database.

It is a diary system to make sure certain information is received by a due
date. The frequency can be anything from weekly to annually and the date of
receipt can vary after the date e.g. info due as at 30/9/08 can be received
up to 45 days after the event (or 30 or whatever) depending on the customer.
Rather than rekey a monthly item 12 times is there a way to effectively copy
and paste the fields for one month and then go through and change the date of
the information to Jan, Feb etc. OR ideally is there some code that will take
the first record and just create a second and subsequent record based on the
frequency.

I should mention that there is a posiibility that more than one month's
information is overdue i.e. we are still waiting for Jan and Feb information
and need to know that fact so in my mind I do need more than one entry to
cover that eventuality.

All suggestions welcome! ps I am a relative novice on Access.

Thanks

 

[Allen Browne]

For some ideas to stimulate your thinking, see:
Recurring events
at:
http://allenbrowne.com/AppRecur.html

The article explains the technique of using a cartesian product query to
generate the occurences. You could then turn that into an Append query if
you want to write them to a table, or it explains how to generate those on
the fly.

It goes on to explain how to handle exceptions, but I don't think that
applies for the situation you describe.