I created a report where it lists a set of items from a particular time range. When these items are included in a report, I would like to set a value in my table to true\1, indicating that they've been addressed. How would I go about doing this?
Competent Performer
Windows 7 64bit 
Access 2010 32bit
I created a report where it lists a set of items from a particular time range. When these items are included in a report, I would like to set a value in my table to true\1, indicating that they've been addressed. How would I go about doing this?
Who is John Galt?
Windows XP Access 2007
One way would be to run an update query using the same time range as a criteria.
Competent Performer
Windows 7 64bit Access 2010 32bit
Ok, so I created the update query which is working. Is there any way to automatically run this when the report is ran? I am using a navigation form to view the report (if that helps\matters)
Who is John Galt?
Windows XP Access 2007
If there's code or a macro running to open the report, the query could be run immediately after. You could also use the open event of the report to run it.
Competent Performer
Windows 7 64bit Access 2010 32bit
Thanks for the help baldy, it's working as I want it to now.
Who is John Galt?
Windows XP Access 2007
Happy to help.
Parent Item / Child Item Not Saving Correctly Together
Totals for records not included in report
Posting Permissions
Reply With Quote