Newbie needs help

[teormond]

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.

[kfleming]

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

[teormond]

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