I created an Attendance report that sorts by individual employees. In the footer section for each employee I used the COUNT function to tally the number of attendance occurences that each employee has. I need to be able to have a disciplinary step printed out in the footer for each employee that shows us the stage that the particular employee is in. For example, Employee A has incurred 3 tardies. I need the words "Verbal Warning" to appear on the report. First of all, can I use an IIF statement on a report to calculate something? My IIF statement is written as follows: IIF COUNT[JOBS]= 3 THEN "VERBAL WARNING". I keep getting syntax and missing operator errors. How can I make this work. Should this be done in the query that the report runs from? If so, how?
Please Help!!!
Thank you
Please Help!!!
Thank you