Limit records in update query

[psbsmms]

I have a database for collections and I am triing to mail 200 letters a week and mark the client table with date of last mailing. So far I can select query limit to the top 200 however when I try to change the current select query to an update one I loose the ablity to count records. What I would like to do is make one button that runs the select query, prints the report and then updates the client table with last date of mailing. I am totally unfamilure with ADO and DAO recordsets as I am a recent convert from an tottaly different database program.

 

[fwatanabe]

Have you tried using 2 queries? If you create the Select query (limiting it to the top 200 records) and save it, then create a separate Update query based on the Select query, would that work?