Update Query Help

[OC2]

Hi,

After creating an aging report, ive learnt that to update the whole table, I need to use an update query.
Could someone pls explain to me how I could use this query to do the following.

I have a text field that calculates the no. of days from transaction creation to transaction close. If this exceeds 1 day I need the query to recognise the "Open" in status field and change it to Overdue and colouring it red.

Current I have this working through VB code, but it will only update once i have clicked the record which in turn then updates it to the correct status.

I need this to update all records automatically so I can view the records in table format rather than in single form view.

Could anyone help me on this

thx

 

[paron]

It sounds like you could use "Open" as a criterion in the STATUS field, and the same calculation of elapsed time as a calculated field (ETIME or something) on which the criterion would be >1 day. Use "Overdue" in the Update To portion of the QBE grid for the STATUS field, and that ought to do 90% of the job.

Now, the make-it-red part would have to be a function of the form on which your data is displayed, I think.