Filter records not meeting criteria

[DubboPete]

Hi all,

I have a table of training records, and I want to run a query to
filter out a list of staff, from a staff table, which indicates those
who haven't completed a particular course.

TblStaff and TblTraining both have [EmployeeNumber] field
relationship.

TblTraining has [CourseCode], CourseDesc] fields
example 363, Fire Training

I want a list of staff from TblStaff who haven't completed their fire
training in the last 9 months...

Hope that makes sense!

thanks in anticipation and cheers

DubboPete

 

[Allen Browne]

Use a subquery, Pete.

Example in:
Subquery Basics: Identifying what is NOT there
at:
http://allenbrowne.com/subquery-01.html

 

[DubboPete]

Hi Allen

Fixed Thanks for your help@!
Pete

Use a subquery, Pete.

Example in:
Subquery Basics: Identifying what is NOT there
at:
http://allenbrowne.com/subquery-01.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi all,

I have a table of training records, and I want to run a query to
filter out a list of staff, from a staff table, which indicates those
who haven't completed a particular course.

TblStaff and TblTraining both have [EmployeeNumber] field
relationship.

TblTraining has [CourseCode], CourseDesc] fields
example 363, Fire Training

I want a list of staff from TblStaff who haven't completed their fire
training in the last 9 months...

Hope that makes sense!

thanks in anticipation and cheers

DubboPete