Reset number after one year

[hootie318]

I am currently working on a db to handle our FMLA time. I keep a continous form that totals the time used and subtracts that from the starting amount. One year after the time is used their total should grow. I am looking for some code that will not calculate any record that has a date beyond one year from the current date.

 

[hootie318]

I have tried this code, but it did not work:

If Me.Date < Expired Then
Total = Total - Me.Hours.Value
End If

 

[vangogh228]

Perhaps you could have a checkbox called "Expired" and have an Open Form action that turns the value to True if the corresponding date field is

>date()-365

and False if not.

Then you could query the values for the "False" (unchecked) records and put a sum function in a text box, or just put it on a report. You could even hide the checkbox in the form.