Attendence

[cyberhorse30]

thread702-1741110

not to be too much trouble but can someone help me figure out a thing or two on this calender? I have been able to add my employees and get the weeks to start with Saturday and even get it to look back 365 days from today in the absentee report for a rolling year and a few other things. What I would like to do is remove the sub-form at the bottom of the year calender and (main input screen)and add a form that either just displays the vacation days used during this calender year showing or add that info to the absentee report itself. Any ideas? Thanks in advance!

 

[LaurieHamlin]

1. How do you want to show the vacation days for the year? Showing on them on a calendar is not practical for an entire year. Personally, I would list them.
2. What version of Access are you using?

Laurie

 

[cyberhorse30]

Hey Laurie, Thanks for your response. I am using 2010 Access. Here is a link to the calendar as I have modified it so far. oxicottin and MajP (from this forum) and Im sure a few others built and designed this calendar and it is really, really good...I take no credit for it whatsoever, simply a very grateful user. What I need to make it do at this point is to have it count vacation days used by calendar year Jan-Dec. and place the number at the bottom of the screen instead of the sub_form that is there now. I also, if it isn't too much trouble, would like to add a statement to calculate the number of vacation days available, here is what I have so far, but it wont let me enter it:

TotalVacDays:IIf([YearsOfService]<=0,0,IIf([YearsOfService]<=.5,5,IIf([YearsOfService]<=5,10,IIf([YearsOfService]<=6,11,IIf([YearsOfService]<=7,12,IIf([YearsOfService]<=8,12,IIf([YearsOfService]<=9,13,IIf([YearsOfService]<=10,14,IIf([YearsOfService]<=11,15,IIf([YearsOfService]<=15,16,IIf([YearsOfService]<=16,17,IIf([YearsOfService]<=17,18,IIf([YearsOfService]<=18,19,IIf([YearsOfService]>=20,0))))))+IIf([BoughtVac]=True,1,0)

It calculates based on years of service as of July 1 of each year. If you look at the reports at the top of the input calendar I need my absences, tardies etc to calculate on a rolling year, which I figured out. Vacation days however are calendar year and I would like to have those on the report as well. So I guess I would like two numbers at the bottom of the main form one showing Vacation days available, and one showing Vacation days used. Thank you for any insight you can bring.

 

[oxicottin]

Do you mean like this? This is what I did for my vacation.... This is the totals in the (subFormVacPDSDSummary). The syntax I used is:

=[txtVacHoursLeft]\8 & "d/" & [txtVacHoursLeft] Mod 8 & "hrs"

Hope this helps....

Thanks,
SoggyCashew.....