Hi Everyone,
Im developing an attendance DB which should keep track of the employees sick and vacation days among others. Iam creating a report which should show the vacation days on a specific employee, however I would like to sum or count the amount of vacation or sick days this employee had taken already. The data resides in a table called calendar which is populated from a subform. The subform simulates a calendar in which the rows are named with the 12 months of the yr (Jan, Feb,...) and the columns are named with the days of the month (1,2,3,....31). Each field that corresponds to a specific day of a specific month has a drop down list with the different type of days like sick, vacation, floating, working from home, etc. (S, V, F, WH, etc.)This report should print the spicified type of day in a calendar like report. However I would like the report to show the sum of each day type (total of sick days taken , total of vac taken, etc... all individually). Does anybody have an idea of a function or any type of way in which I can achive this?
Thanks so much in advace, any help will be greatly appreciated!