K
Keith
I have a for that records holidays. The user inputs the start and end dates
of the holiday and the number of annual days used and the number of public
days used.
In the footer of the form I have a running total for annual and public days.
I should point out that the form is set to datasheet view and used as a
subform. The main form then pulls through the running totals.
This all works great. However, I want the running total to only count the
days where the start date of the holiday is in the current year. I don't want
it to count the days for an entry that has been put in for next year.
Anybody got any ideas?
of the holiday and the number of annual days used and the number of public
days used.
In the footer of the form I have a running total for annual and public days.
I should point out that the form is set to datasheet view and used as a
subform. The main form then pulls through the running totals.
This all works great. However, I want the running total to only count the
days where the start date of the holiday is in the current year. I don't want
it to count the days for an entry that has been put in for next year.
Anybody got any ideas?