The attached database is used to track the time and attendance of employees in my department and especially to calculate remaining vacation, approved absence, personal day, and award day(s), hours. These balances are displayed in the time sheet report. It has worked fine for years except when it gets to the end of the year when vacation time for example, reaches zero. At that point the report displayed the vacation hours held at the beginning ot the year. I thought I had this fixed in qryBalanceReport3, until I ran into a new issue with Approved Absence hours, alias sick time. Most employees use their sick time during the year, but a few go for perfect attendance.
My past expression in qrybalanceReport3 was RemA: IIf([SumOfRemA]=0,[AAHrs],[SumOfRemA]) which worked for the perfect attenders but not the users. My new expression RA: IIf([RemA]=[AAHrs] And Format(Date(),”mm”)>9,0,[RemA]) works for the users and not the perfect attenders. Obviously I need something that works for both.