Currently, I can print one month (in calendar style) per page with events (sick, discretionry day off, vacation, etc)
here is the table.
ItemID - AutoNumber
UserID - Text
EntryDate - Date
DateWord - Date
WorkType - Text
WorkItem - Text
Hours - Number
Comments - Memo
Ga_Number - Text
Dept - Text
Here is the sample database (Please populate some data) [url removed, login to view]
frmLeaveRequest displays one month activity
rptMyCalendar print the same info display in the form above (frmLeaveRequest)
I have also attached how all 12 months in one report should look like. Can anyone please help me ? Most of the work is done and I am sure just little tune up is needed to accomodate all 12 months on one page report. This should be simple task since majority of the work is done.
Filter on the frmLeaveRequest should stay the same. May be you can put a button "Print Yearly Calender" to print the report.