Search results

I guess I didnt explain that very well! My unmatched query returns employees with no records at all in the training table. What i need is too get records of people with no entry of a certain "TrainingType"and add this to my previous query. Thanks in advance for any help.

I tried that today and with no luck as the example I found had two related fields. In this Database there is the Employee table, Departments Table, Training type table and the table that stores the training records by employee and training type and date. I need to return training that an...

Thanks! I will work on those field names. I tried your code and it returns the same values. What I'm trying to return is an "Incomplete" If they have not completed the course this calendar year or ever. That part is working fine provided they have taken the course in the past what I cant get my...

I'm trying to state that every employee less less than max date is incomplete or greater than is complete for some training. This works fine however, I need to list employees with no entry as incomplete as well. Here are my two queries: SELECT tblDepartments.Department, tblEmployees!LastName...