Using values from a report to run an update query

P

Paula

I am trying to use an update query to set values in a table, based on values listed in a report. The report is based on a query that asks the user to enter a state. Once the state is entered the report is produced. On close, I call an update query to update a field called "viewed" to Yes, based on the results of the report. My update query partially works, but it only updates the first record showing in the report. How can I make sure that all of the records of the report are updated (select all)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Rounding decimal values in forms and reports 2
Update a Report from a Form 0
Update a Report 28
filtering a form based on a filter on an open form 2
Cross Tab Report Vs Dynamic coulmns 0
Adding Additional Fields to a Report Created Using Wizard -Access 2
Getting a Form recordset to a Report 4

Top