going forward you have to enter in a renewal date, and the after update properties of this will be renewal date less 90 days - or incpeted date + 270 days on the assumption annual - you will have to run a qry to do your historic stuff and the same again for your 30days after 90 days or 60 days prerenewal /or 300 after inception , then is a simple case of run your report off based on this critei - I would have a form for running this sort of thing off
call it renewals or whatever .
from and to (date fields ) and this will look at your date field if its in this range run report off ( I presume it will be a standard letter) thne have another button which will run the 30 days off , now on both these option you want some how to have a don't do option , recommend a tick box or some other field where you can filter this out
just a starting point you may also want a outstanding list box on the start of your d/base which would show you a list of cases where you have not run off the letter, if thats the case then take it up a notch and have a date letter sent on each 90/30 option and after you run your report have in the code behind the button and update qry to a update you ds/base that 90day letter sent on dd/mm/yyyy then you can see if you have sent a letter out or not the outstanding box on load would see where cases have no letter sent and are in a defined date range say ()now - 7 days
just an idea - none of what I've burrbled on about is rocket science all Access qry no need for VB coding - theirs probably better ways of doing this - but this came straight to mind
