Select & Update Query Or Sub Query

[esu4edp]

Ok,here it goes. I have a form that a user inputs two date ranges on. Once entered it runs a query based on those two dates and returns records of expiration dates between the dates, and then generates a report. This is just a general report (list) with their name and address and the date they are late. All of this works great and I have no problems.

Now I want to be able to have those records that fall between the two date ranges the user enters, update a "yes/no" box to "Yes" and then print out a nice form letter for them with their info on it and some your late to renew your lease wording along with the general list report. I have this report done also, and it works fine, I just want to be able to have somekind of an update query based on the original select query that updates the box to yes becuase their lease is late on being renewed, and then print a form letter based on the query of the form letter.

thanks
Craig

 

[dhookom]

I would do this in two extra steps. Once the report has been printed, run an update query that sets your field value as required based on the two dates. Then run your form letter report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.