I have to send bereavement cards for anniversaries of death every three years for the month of bereavement. (eg any clients who died in the month of June 2014 or 2013 or 2012). Next month (July etc ) the same will recur. At present, I raise a query where I show the query Start Date 1/6/2014 End Date 30/6/2014, OR Start Date 1/6/2013 End Date 30/6/2013, OR Start Date 1/6/2012 End Date 30/6/2012. The same procedure is processed for the months of July, August etc etc. I wish to create the report based on the query where staff who know nothing about Access. There is an Access table of the names and dates of death. but only the dates of deaths. How can I make it easy for them to produce this report each month ? I know little about VBA, but a reasonable knowledge of Queries and SQL.
Thanks in advance
John D