Hi Richard, First of all thanks for such nice and detailed teachings which helped me to understand Access better. I have one table of Bank Gurantee for customers of a company where I need to issue notice letter on the basis of Bank Gurantee Due date. With the help of automated query I could solve upto Notice Query. How can I generate reminder letters for all the customers to whom notice has been served but no reply.

Thanks in anticipation of a positive reply.

---

Reply from Richard Rost:

The easiest way to do this would be to create two boolean (y/n) values in your table: NoticeServed and HasReplied. You can turn the NoticeServed values ON when you generate your letters the first time (an update query would work fine). Someone will have to check the box for HasReplied for the people who do reply. Then, just make yourself another query where NoticeServed=YES and HasReplied=NO and use that to create your letters.