I would like to create a query that would do the following give me all dates that occurred within the last six months triggered by a date entered into table which when reached it would trigger an email being sent. To explain more detail I am working on a funeral home database. (Which seems like a never ending but I am learning so much so I want to keep building it). Once I enter the date of death field name (DOD) I want query to all deaths that happen prior to past six months from current date. Which would trigger and email that would notify me to send a follow up letter for family. How would I achieve this any ideas? Once again I am a novice and I want to thank everyone in advance for all their help, I could have not did any of this without this forum.