Default Value does not change for old records

[harpreett.singhh@gmail.co]

Hello,



I have a column for default value of today's date "Date()". In the next column there is formula for no of days which calculates as

No. of days = ([Today's Date] - [Audit Date]/7*5 (/7*5 excludes sat and sunday).

My problem is that default value of date does not change as i open the table everyday. I know why. Coz i introduced the date column after 200 records already entered.

Now today's date only changes if new record is inserted.

How to get current today's date everyday automatically ? when we open the database next day !

Please note that I am using Today's date only for calculating number of day's formula. otherwise no function of this column.

Regards

[ItsMe]

Are you trying to use a formula in a table? There is a data type "Calculated" in newer versions of Access. I try to keep my tables simple and use queries, forms, and reports to do the heavy lifting. I would use VBA to calculate a formula and not store the calculated data in any table.