Updating tables automatically

[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

 

[lameid]

Use the same code from the form on a report's on format event to display the data... There maybe problems and you'll have to use the On print event or some mixture. Good Luck.

 

[quest4]

I would do this i n a form and have some Command Buttons on the form to run the query, in a macro, and print the report. Just a thought.