update table field

[amoona]

Hi,

i'm not sure if i should display this q in the reports section or queries...

is it possible to update a field in the table from the report or the query which generates the report?

i have a field in a table which should get the date when the report is generated (the date should only be entered in the rows which were displayed in the report)


please help!!

 

[tomj]

Update query

Since you are using a 'select' query to generate the report, why not create a 2nd query like the first only make it a 'update' query to update the date field with the current date, i.e., DATEFIELD = date()

Create an event procedure to run the report and run the 2nd query within the event procedure to update the field.