DataPig Access Training
Thank you for taking the time to report an issue.
What's wrong... Please write below.
and my skills are not good enough to amend microsofts employee example as there are too many sub forms and things I would have to change that I don't have the knowledge to do.
Right now, I just have a basic table and everytime someone either provides/receives training, another record is entered, but which creates a lot of records. Is there a more efficient way to set this up?
I am trying an if statement but it does not work it only sums all training hours.
How can I sum only state training hours? Here is what I have tried so far.
What is the best way to do this in Access, keeping in mind that ease of data entry is a must, since I have a lot of departments and there employees to track? What I need is to be able to create a attendance roster for a department and update of the employees at once if possible.
The table I am working with is mainly based on the date of training and the training type (which determines whether the training expires on the 1st of the 13th, 25th or 37th months or if it keeps the same date); what I would like is for the end user to input the data into a form, have it autocalculate the expiry date on the form so they can verify the information and then once the form is closed, have this information fed into the table so that we can print training reports for the managers.
I'm not versed in VB and am reaching my limit of understanding with queries,
I can produce a query to show me the list of people who HAVE the training. Currently, this produces a list of 123 employees who have the training.
I would like to produce a list of people who DO NOT have this training. This list would therefore produce a result of 25 people as we currently have 148 on staff.
It is a painful process digging through to find out who we need to get into training.
Trainings are organised in training sessions, since a session can contain more than one training (i.e. First Aid, CPR, and Fire extinguisher)
Employees belong to departments.
Certain trainings are required working in a department, that dictates requiered trainings for an employee.
Now I have two queries:
'Query emp trng req' returning employee id and their requiered training id
'Query emp trng done' returning employee id and their completed training id.
Obviously I like to know which of the 'req training id's' are missing in the 'done training id's' per employee id
There can be training id's in the done query, that are not requiered for that employee.
I have the dBase attached, had to strip a lot from it down to <500k
I need to create a report showing who need to retake the training because it has expired for that person. I have a query that results with all of the employees that have taken the procedures with an expiration.
every person could work in multi Workplaces.
I want to make a Query of this table, and to add a new field (Training) in minutes which hold an Expression,
(Training = 900 - worktime)
the next Training field should contain the (900- last training value) of the same PersonalID and Workplace