I have a report built on a query that has a date prompt parameter box. I would like to update a separate date field (date completed) each time the query is run through the report option.
So, I still want the results of the main query to appear in report form, but I want the subquery to update the date completed field at the same time. Can this be done?
I tried this in the criteria field of the date completed field on the query
(UPDATE Refund Letters
SET date completed = Date()
WHERE = ALL)
I keep getting a syntax error message.
I'm stuck.
Thanks
Stacey
So, I still want the results of the main query to appear in report form, but I want the subquery to update the date completed field at the same time. Can this be done?
I tried this in the criteria field of the date completed field on the query
(UPDATE Refund Letters
SET date completed = Date()
WHERE = ALL)
I keep getting a syntax error message.
I'm stuck.
Thanks
Stacey