Just starting out - confused by tutorials

[DHFE]

Have you even looked at the example Db that Bert uploaded?

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.

Ok then you surely have enough information supplied to create a database?

If I did then I wouldn't be asking questions on how to do something would I? Are you even reading my posts?

[mike60smart]

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:-

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));

This produces the following results:-

[Micron]

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.

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).

[DHFE]

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

[CarlettoFed]

In the attachment you can see an example.
StaffCerts 01.zip