Floating Holidays that are not available every year (1 Viewer)

[ladyrider696]

I have a Floating Holiday that doesn't happen every year how do I incorporate this in Access 2010, I have a report that calculates Paid Time Off for employees and when they have a year that has a Floating Holiday or doesn't have a floating holiday, how do I incorporate that into a query or report without losing the calculations from the previous year reports.

for example, this year a floating holiday is allowed so my calculations work, but next year if a floating holiday isn't allowed how do I make it a 0 without losing this years data.

I tried tblFLOATINGHOLIDAY with several years listed (at first used Yes/No) and a field that you either put 8 or 0 (8 hours or 0 hours). Then I used a query combining tblEMPLOYEES and tblFLOATINGHOLIDAY with citeria for FLOATINGHOLIDAY to be 2015 so all the records would show 8 under FLOATING HOLIDAY. But it comes up with no records.

 

[Ranman256]

you need a table that has EVERY holiday date.

 

[CJ_London]

Can you clarify that a floating holiday can be taken at any time by the employee - a date does not need to be specified for the purposes of what you are trying to calculate. Also confirm what a floating holiday is -- a day, a week, several days that can be taken separately?

 

[vbaInet]

The table could look something like this:

FloatYear	FloatHol
---------	--------
.
.
.etc
2012	    	    0
2013	    	    8
2014	    	    0
2015	    	    8
.
.
. etc

For 2015, you first create a query with criteria "[FloatYear] = Year(Date)". Save and close the query and add it to your PTO query (as it will only return one value). From there you can add [FloatYear] to PTOHours.