Liveware Publishing Support Forum

Greetings. I^m new to Report Writer and need some help. Our company database contains training records for each employee. I need to run a report listing all employees who have NOT attended a specific class. I tried using CourseNo "Is Not Equal To" the specific course but the results are incorrect. Can anyone offer any advice or guidance. Thanks in advance.

Sort and group the report by employee.____Then create a total field that counts the COURSENO field. But add a condition that says:__COURSENO=^xxx^____Where xxx is the course that you want to determine which employees have not taken.____Make this total field pre-processed.____Then in your query include all records where this total is equal to zero.____It will give you a list of employees who have not taken that course.____Kathleen__R&R Support

Thanks for the reply Kathleen. You^ve saved my life! (and I learned something new to boot!)