I have a question regarding the best way to perform a data filter. I have a database of all of our employees (employee table) a list of trainings they can complete (training table) and a table that joins the two (training completed table). I have been able to build out report pages to show employees and the training they have completed and everything is working well. We have a number of different training that are required of specific populations within our employee group. What I want is a Datapage that someone can filter those that have not completed a specific training. For example take the full list of employees and compare it to those employees that have completed training and return a list of those that have not. I have been able to do this to a point but whenever I log any training for an individual it will not show them for the specific training I am looking for (if they have completed any training it shows them as completing the specific training). This is easy to do in MS Access but not so much here. Does anyone have any advice on how I can make this happen?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
smcdonaldwyo
I have a question regarding the best way to perform a data filter. I have a database of all of our employees (employee table) a list of trainings they can complete (training table) and a table that joins the two (training completed table). I have been able to build out report pages to show employees and the training they have completed and everything is working well. We have a number of different training that are required of specific populations within our employee group. What I want is a Datapage that someone can filter those that have not completed a specific training. For example take the full list of employees and compare it to those employees that have completed training and return a list of those that have not. I have been able to do this to a point but whenever I log any training for an individual it will not show them for the specific training I am looking for (if they have completed any training it shows them as completing the specific training). This is easy to do in MS Access but not so much here. Does anyone have any advice on how I can make this happen?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.