Bert? Is there another upload or did you mean Bob?
Yes, I looked at that, it had a few tables in it - I'd already got to this point myself.
If I did then I wouldn't be asking questions on how to do something would I? Are you even reading my posts?
Bert? Is there another upload or did you mean Bob?
Yes, I looked at that, it had a few tables in it - I'd already got to this point myself.
If I did then I wouldn't be asking questions on how to do something would I? Are you even reading my posts?
I have been reading and from Bob's example database I modified it slightly so that the table fields are as follows.
Then I created a query as follows:-
This produces the following results:-Code:SELECT tblEmp.EmpID, tblDept.Dept, tblJobs.JobTitle, [FName] & " " & [LName] AS Employee, tblEmp.Active, tblCerts.Cert, tblEmpCerts.DateCompleted, tblCerts.ValForMonths, DateAdd("m",[ValForMonths],[DateCompleted]) AS ExpiresFROM ((tblDept RIGHT JOIN tblEmp ON tblDept.DeptID = tblEmp.DeptID) LEFT JOIN tblJobs ON tblDept.DeptID = tblJobs.DeptID) LEFT JOIN (tblCerts RIGHT JOIN tblEmpCerts ON tblCerts.CertID = tblEmpCerts.CertID) ON tblEmp.EmpID = tblEmpCerts.EmpID WHERE (((tblEmp.Active)=True));
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Unless I've forgotten something it seems you have what you need to take the next step, which would be to design tables, create the relationships and post a pic of that if you want feedback (or post your empty tables, or tables with fake data in them).All the users really need to know is; who does or doesn't have a specific certification, and when they are about to expire. It doesn't need to be more complicated than a list of people, certificates and dates.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Sorry for the delay, was given some actual work that had a short deadline.
I'm past the creation of tables, and I've created several queries which show different date ranges of all certificates (I.E. Expired, 30 days to expiry, 60 days to expiry, 90 days to expiry)
What I need to know now is;
how to allow the user to select a specific certificate to get a list of everyone who has or hasn't got a completion date for that certificate (view information)
similarly have the user select an employee and see all the certificates they have or haven't got a completion date for (view information)
And also allowing the user to manipulate the data - adding/removing/updating employees/certificate information etc
In the attachment you can see an example.
StaffCerts 01.zip