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.
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.
In a second table(training table) I have employee ID, Last name, First name, date and training topic.
I have developed a clumsy form which displays ID, last and first name at the top and a subform appears below with last name, first name, date and training (topic).
Problem #1. I sometimes know the first and last name, sometimes one or the other, and I never remember the ID number. I need a way to enter a last name, locate the first name and IDnumber, and have the last and first name automatically populate the sub form below.
Problem #2. I need to print each person's training list on an individual page. Not versed enough to do this.
Problem #3. I have used Paradox to collect this data since about 1995. some employees have been here at least that long so I have databases with associated forms that need to link for a complete list of training to data. I am much better at paradox than Access so I am fumbling.
I created three tables; tblEmployees(PK -Employee ID), tblTraining(PK - TrainingID), Course (PK-CourseID)
My problem is that I created a form, and a subform. But I cannot get both forms to be in Synch. Meaning once I select an employee, listing the training history of the employee. I would also like to be able to additional training information for each employee. I feel that I am almost there, but I am not sure what I a missing.