Good idea! But your solution depends a little on your progamming level. Adding a yes/no field to a record does not require great skill, but setting it's value based on the report generation (and message sending?) is a little more difficult. 'GGleason' is right to suggest an update query, but...
I have found Excel to be extremely handy for resolving data issues (splitting data elements, search & replace text, combining fields etc). Use it to form a data table that can then be imported into Access. I haven't seen your example, but I hope this helps.
-Tim
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.