Nige
It is not wise to store calculated values. All you really need to do is put the expression in your form's query. You can also do that in any reports you might have that show the number of days.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "nigelhjackson" <nigel@...> wrote:
>
> In this warranty database I'm cobbling together I have a field for Warranty Days Left. When a record is added that field is calculated on an AfterUpdate event of another field using WarrantyExpiryDate-Date.
>
> Obviously all the expiry days left need to update each day, when a user opens the form, and the new values (normally 1 day less!) stored in the table to replace the existing.
>
> BUT...I don't know how to do this!
>
> Can someone please help with a description of how to do this update when the form loads, and/or some code. I'd rather do the update automatically, but if I have to put code behind an 'Update' button that'll be fine.
>
> Thanks, Nige
>
Tidak ada komentar:
Posting Komentar