Query Problem

[Darrell Wootton]

Hi,

Can anyone me with this problem.

Query 1: People Who Cancelled a Course
Query 2: People Who Attended a Course

Fields: DelegateUID-CourseName-CourseDate-UserName-CancelledCourse

From the queries shown I need to create a list of people who cancelled a course (EG: CourseB) but who then never attended the same course (CourseB) at a later date, ie they are still required to attend CourseB training.

I only want to search cancelled users.

Sorry if its a bit long winded.

Thanks

Darrell....