Rollover

[axm0035 via AccessMonster.com]

Hello,
i am trying to create a table where the data entered will have a rolling 12-
month period. Occurences will be calculated on a rolling 12-month basis.
example: an employee can only be absent 3 times in a year. after a year, the
report will reset to 0.
Please i will appreciate it if you help me with this.
Thank you in advance.

 

[Larry Linson]

You describe building business-rule intelligence into a table. That would
not be a good idea, if you could figure a way to do so. Tables should store
data, and applying business rules should be done in Queries, Forms, and
reports using either macros or VBA code, if needed.

If you have Employee Records that indicate absence on a date, it is
relatively easy to select the dates for the preceding year using the current
date, as returned by built-in function Date(), in combination with the
built-in function DateAdd, to subtract a year from the current date.

Larry Linson
Microsoft Office Access MVP

 

[axm0035 via AccessMonster.com]

Thank you Larry.

You describe building business-rule intelligence into a table. That would
not be a good idea, if you could figure a way to do so. Tables should store
data, and applying business rules should be done in Queries, Forms, and
reports using either macros or VBA code, if needed.

If you have Employee Records that indicate absence on a date, it is
relatively easy to select the dates for the preceding year using the current
date, as returned by built-in function Date(), in combination with the
built-in function DateAdd, to subtract a year from the current date.

Larry Linson
Microsoft Office Access MVP

Hello,
i am trying to create a table where the data entered will have a rolling

[quoted text clipped - 5 lines]

Please i will appreciate it if you help me with this.
Thank you in advance.