Append query issue

[Stuart Green]

I am writing a database to record the number of Health and Safety checks made in our building. There is a list of the checks to be done held in a table and at the beginning of each financial year the frequency of these checks is set. So, for example, for year 04/05 I may decide to do 5 emergency building evacuations. I have a form with subform that records the year and number of checks to be done in that year against each risk but what I want to happen is if I record 5 emergency evacuations I want an append query to append 5 blank records in another table that I can subsequently record comments in. In addition I would like these 5 blank records to be incremented in such a way that the date they are due is calculated. So, if the year starts 1 April, then the first check is due in 73 days time (365/5), next check in 146 days etc. In this way I can run a report looking for checks that are due to be done or haven't been done in the required time scale. Any ideas please?

 

[Stuart Green]

Well I have managed to work out how to create the correct number of blank records using WHILE and WEND, but the incrementing date issue still has me stumped

 

[Stuart Green]

It's OK, I have cracked it! (had a road to Damascus moment). Would delete this thread if I could

 

[Mile-O]

Would delete this thread if I could

You can; but don't.