Printable View
Hi
I have an access database with a field called "Days remaining" now what i need to do is, say if an amount of days gets added to the field for instance
365 then everyday that amount must decrease by one. is this possible, please can someone help me.
Many thanks
If you mean by just using sql Server you could just have a scheduled task that runs once every day and runs an sp that updates all values for that field which are greater than 0 by minus one.
Alternatively you could have a View, which contains the other fields from the table, and this field calculated using SQL.
This method will slow down access to the data tho.