Query to remove record from table and return balance of list 1

[IBstupid]

I have a Job Performance Review table with 50 JPR tasks. This is call tblJPRlist. I have an employees table called tblEmployees.

When an employee or a group of employees complete a JPR I have a form, frmEmployeeJPRCompletionQuery, that inputs the information to tables called tblEmployeeJPRCompletion and tblJPRCompletionList which are joined by one to many relationships along with tblEmployees.

I am able to generate a report of the individual employees showing the employee ID badge number, date and various JPR's completed.

I have not been able to figure out a way to make a query which will allow me to generate a report that shows all of the employees and which JPR's they still need to complete.

In an effort to solve this I have created a query, qryEmployeeandJPRlistCombination, which shows every employee and JPR that they initially needed to do. Using the qryJPRCompletionList and qryEmployeeJPRCompletion with various joins and null values have produced some interesting effects, but all the wrong data.

I have exhausted my limited knowledge would greatly appreciate help from the experts. Thanks.....Tony

 

[jjlogan]

IB -
Suggest that you fill out the employee x task table with 100% of all employee x tasks. You will eventually have to expand this table as employees complete their tasks. Include in this table a status field (yes/no) and upon completing a task have the update form set this status flag. Then you could run status reports from this employee x task table very easily.
There may be another approach, but why not build the above table up front rather than appending to it as you go.
Jeff

 

[IBstupid]

Thank you for your help, it put me on the right track. The problem I had was adding any new employees and then having the table listing them and their JPR's updated. Using your valuable advise and through a series of update queries and make take queries this was able to be accomplished.

I really appreciate all your help and the efforts of everyone to help solve problem that are beyond the scope of the capabilities of people like myself.

Thank you again!