Search results

Currently my table structure is: tblEmp EmpID EmpName Status Type CraftCode tblCertification CertID CertDescription tblEmpCert EmpCertID EmpID CertID CertDate CertExp CertState CertNumber CertAgency But not all of the table EmpCert will be filled out. For example, CPR has two distinctive...

I am on my last piece for my database and I am having the most trouble with this last piece. What I have created is a database which tracks employee skill levels, OSHA and state licenses. The last part of the database is the certifications that an employee may or may not hold. And here is...

I do have a single table for the record source. The SQL statement I posted is similar to what I want to create for the certifications. I have a tblCertifications and then tblEmpCert. I have created lookup tables several times for this database (mostly one to many relationships) but I am...

I am working on creating a query to base a form on. I've done it several times in this database, but today, for some reason I cannot figure out how to do it. I believe this is how I did it before but it looks like the SQL statement got wonky: SELECT tblEmpInfo.EmpInfoID, tblEmpInfo.EmpIDFK...

Ok, thank you...working much better now!

The PK for both is EmployeeID. So I think I would have to add the field EmpCertID and use the indexing there rather than on the original field of EmployeeID so I can create a one to many relationship between the tables?

I've figured out the indexing for the table, however I cannot get tblEmpCertifications to have a relationship with tblEmployee. What am I doing wrong??

I had originally had in tlbEmployeeCertifications listed like this tblEmployeeCertifications EmpCertID EmpID Certification ID CertificationDate CertificationExpiration Was I wrong in thinking that I needed to have a PK that I could just do an autonumber for?

Thank you!! I was leaning towards that but I was second guessing myself.

I am adding another portion to my database and since this is a little different than the other parts I created, I wanted to get some input from the experts. I am adding Certifications to my database. I am currently tracking skills, OSHA, & Licenses for all employees. My current count for the...

Thank you very much!!! It works!

Thank you!!! Now I have one more question. Since I am working with dates in the conditional formatting it does not like when I type in words. For example, the first condition I want is if the field value is less than the Current Date I want it to be Highlighted and text in red. The second...

I created a query for my database to track licenses for my employees. My questions is I want to see on the query/report exactly which licenses are out of date and going to be out of date in the next month. Ideally, I would like to have the out of date licenses show up in red and the going out...

Here is the relationshipship report that shows all the tables and their relationships. The main table's PK is the EmpID which links to most of the other tables so I can link all the records back to one specific employee. Thank you!

I am looking to link two tables as I would like to have reports generated with info from those two tables. tblEmpInfo EmpInfoID <PK> EmpIDFK <FK> Jobsite<FK> tblEmpRating EmpRatingID <PK> EmpIDFK <FK> EffectiveDate SuperID CraftCode StatusChange What I would like to do is have those two...

It seemed to work! Thank you!! SELECT tblEmp.EmployeeID, tblEmp.EmployeeName, tblEmp.CraftCode, tblEmpInfo.JobNumberFK, tblJobs.JobSite FROM qryMaxEmpInfoID INNER JOIN (tblJobs INNER JOIN (tblEmp INNER JOIN tblEmpInfo ON tblEmp.EmployeeID = tblEmpInfo.EmpIDFK) ON tblJobs.JobNum =...

I am trying to get the last record/job number entered for each "active" employee. I have uploaded my relationship report as well as the design view of the query. For example an employee may have worked three jobs in the past year but I only want to see his last job entered. Does this help?

I have exported the data into an excel file. Basically what I am trying to do is I have a table EmpInfo that has EmpInfoID, EmpIDFK, JobNumberFK. This is a pop up form and I log each time the employee has a transfer, lay off, rehire, etc. I want to be able to pull the last entry for the...

That one was not the correct query, I'm sorry Here is the correct query I am currently working on: SELECT tblEmp.EmployeeID, tblEmp.EmployeeName, tblEmp.CraftCode, tblEmpInfo.JobNumberFK, tblJobs.JobSite FROM tblJobs INNER JOIN (tblEmp INNER JOIN tblEmpInfo ON tblEmp.EmployeeID =...

I am coming along with my Employee tracking database, much thanks to you all in the beginning. I have done some tweaking and working around somethings and now I have run into a brick wall on this latest tweakage. I am looking to create a report that tracks the current job site of the...