link data

[soldat452002]

Hi, so here is my situation. I have 2 tables tbluser and tbltraining, the user table has all people register to our site and training table all training information( they must complete 3 modules at any given date). The tbltraining is a linked excel spreadsheeet because it changes daily and I have to manually refreshed it. Here is my ordeal, I need to get a report of all people that completed all trainings( iif statement works) , make sure that in future reports we notify our staff that they already completed the training and another report with people with incomplete training . I wasthinking of creating 2 queues for complete and incomplete butnot sure how to tell the user table that those we processed in the complete queue are done for (linked spreadsheets cannot be updated in access). Any ideas?

 

[Guus2005]

Perhaps you need to test your return or enter key. A question of 500 words in a single line is more difficult to read than when you spread your question over several lines. Now you can say that then enter-key is more expensive than other keys but i don't think so. Every key on your keyboard costs the same amount of money. Was this comment difficult to read? I hope so.

In answer to your question:

You have two tables, tblUser and tblTraining. There is a link between the two: UserId?
You must have a field in the tblTraining table which say: Completed y/n or a date or diploma or another field from which you can determine a course was completed.

If a module contains three trainings/courses you have to know which training belongs to what module. So you need an additional table connecting the modules and the trainings.

When you connect this new table (tblModTraining) to tblTraining you can determine which UserId did not complete a module.
when you left(or right) join the tables you end up with a null value for the training which was not completed.

Can you post a sample database? A database says more than a thousand words.

HTH