Recurring events at different frequencies

[Jesper F]

I have a small db with lab equipment that needs
maintenance a different frequencies.
I have a field with the interval in days (ex. 7, 30, 360)
and a field with date for the first maintenance for each
piece of equipment.

I'd like to be able to enter to dates fx. a month apart:
01-01-2004 and 02-01-20004
and generate a list of the equipment to be maintaned that
month. Since the start date for each equipment is known
this could be done, but are any of you familiar with a
good way to do this scenario?

All the database needs to do is generate the lists of a
coming months maintenance jobs - no storing of completed
tasks is needed.
Thanks for any help, this is a little tricky I think.

 

[martin]

You have to make a decision is it a month or 30 days...

if 30 days then use date()+30 if its a month then use
dateserial(month(date)+1,...). Otherwise you would need
some way of knowing when 30 days and when a month and then
code it.

Martin