Jump to content
  • 0

Employee/Training Database Question


smcdonaldwyo

Question

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

  • 0

Hello @smcdonaldwyo, how are you filtering out the trainings that are completed? If you have a checkbox for example that filters it to be completed, you can either have the checkbox in a search fields of the report DataPage, or have a view that has a criteria wherein the checkbox is unchecked and use it in a separate DataPage.

Link to comment
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...