Subtract query ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. My Employee Log table has employee_id, employee name, Log_date,
Hourly_wage. Employee_id includes all the day or night shift employee id.
Most importantly, some employees sign up without any shift signed up.

2. I have other tables :( Employee_Night_Shift)
It has employee_id with night shift. This table updates every day and
several hundred records.
Likewise in Employee_Day_Shift table.

Q: I am going to add one column: Shift-type in the Employee_Log table . If
employee belongs to Dayshift, I need to put "1", otherwise, "-1". I need to
use query in QBD grid

Thank you.
 
Jay

I am having trouble visualing your current data structure. Could you
provide a bit more explanation?

For one thing, your EmployeeLog table, from its title and contents, appears
to be a log. But if you have an employee_ID, you don't need to also store
the employee_name. In a well-normalized design, you'd have an Employee
table that held employee_ID, employee_name, DOB, and, perhaps, Hourly_wage.
A "true" Log file would only hold employee_ID, Log_date (or maybe
LogIn_datetime, LogOut_datetime).

I agree with your idea of adding a ShiftType column to a table, but that
seems to be particularly redundant to add to the Log table.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
 
Back
Top