Setting Temporary Variable

[KEVWB]

Hi,



I have a calibration database with [next due] and [calibrated on] fields in one table, what I would like to do is store the calibration date, multiply it by a [frequency], say 28 days held in a separate table and then create a new record in the original table with the calculation inserted into the [next due] field, can anyone tell me if this is feasible and if so point me in the right direction.

Thanks in advance

Kev

[TheShabz]

Usually, storing calculated values in a table is a no-no. Something like what you are doing is usually displayed in a report or a form where the calculations are done on the fly. For example, you wouldn't store the "next due" in a table, but rather, create a daily/weekly/monthly/etc report that shows which items are soon due for calibration.

More info here.