Hi. I’m trying to join 2-queries within a query from two different tables. Let’s start with me giving you some background on this database. This is a small database that keeps track of employees who work for me. I only have maybe 40-active employees who are presently working for me. Though this database goes back to 2017, so I have a lot of employees who have been terminated & hired over the years. We’ll just focus on those active employees, which only one employee will work for me on a certain day. Some employees only work for me on certain weekdays, while other employees will work for me on more the one weekday. I have two tables, the first table called, Employees_Info_tbl which holds all of the personal information of each employee. Along with Employees_Info_tbl which weekday each employee usually works & whether they usually work in the daytime or in the evening time. I only have just 1-employee working for me; some days 1-employee in the daytime, but I always have an employee working with me in the evening time. This Employees_Info_tbl also has a check box indicating if the employee has been terminated or if they are still actively working for me. Each employee is given a unique ID (an abbreviation of their first & last name with the first letter of their middle name. i.e. Kim L Summers = KmLSmmrs). The EmployeeID, KmLSmmrs is set as the primary key for this table.
The second table, Employees_Entries_tbl list the employees by their EmployeeID. Along with, all of the dates each employee worked (or works), the amount of time an employee worked, & whether they worked in the daytime or in the evening time. From this Employees_Entries_tbl I created a query to obtain the month, the weekday, & the year from the ‘date’ fld. The primary key in this table is also, EmployeeID (from the Employees_Info_tbl).
I sort of gave you a brief layout of the 2-tables I’m working with & I wanted to create a query displaying the number of years all of the active employees have been working for me. So from the Employees_Entries_tbl /qry I had no trouble creating a query just the active employees & the number of years they have been working for me. Except, what I really want is going back to the Employees_Info_tbl I created a query/form of all of the active employee’s information -&- on this same form I also wanted to see the number of years each active employee has been working for me. I was somewhat able to complete this task by first, creating a query/form with all of the employee’s info (from the Employees_Info_tbl) & I was also able to add the number of years all of the active employees been working for me. Note, I joined the ‘Employees_Info_Active_qry’ & the ‘Employees_Active_CountOfYrs_qry’ on the ‘EmployeeID’. Now here is my dilemma, this query or form cannot be edit & I don’t understand why. I need to terminate some employees who as been working for me the longest & to add some new employee’s info, but I wanted to do this on one form. BTW, when I joined these 2-queries on the ‘EmployeeID’ I tried all 3-different ways in joining these 2-queries & they are all non-edit. I’m not sure if I made any sense here, I tried explaining the best I could.
Any advice/suggestions would be greatly appreciated! Thanks in advance!