Reporting Missing Data 1

[dk99]

Hi,

Help please - I have been struggling on this for days and days, and must be missing something simple.

I have a database that employee's enter there productivity performance in (nothing complicated), I need to report on employees who have not completed this within a given period?

I have a table which contains the employees name (along with other details) and when they enter their details each evening they first of all select there name from the table - if that makes sense?

Any help would be greatly appreciated .....

 

[maxhugen]

Are you storing the productivity info in the Employee table? If yes, I assume that you're just updating a field for a productivity 'value', and presumably also updating a date that the value applies to?

Then try creating a query (eg 'qryEmpProd') that returns the employeeID from the employee table, where the date is the date you're interested in. For the date criteria you might want to reference a date field in a form.

In another query, add the employee table, and the query you created above (qryEmpProd). Link them on the employeeID field, and create an Outer Join (include ALL all records from the employee table). Then add the field qryEmpProd.employeeID to the query, and set it's criteria to "Is Null".

Max Hugen
Australia