Schedule

[Guest]

I have two queries that I need to join the information from. One query is
for employee attendance (i.e. vacation, sick) and the other query is for the
work schedule (when they were originally scheduled to work). How do I
accomplish this?

 

[Diane Walker]

Anna,

You need to find a common field on both tables such as Employee ID or
Employee Name. Then, use Employee ID or Employee Name as a join field for
both tables.

Diane.

 

[Guest]

Without knowing anything about your queries or tables or fields or data all I
can suggest is to use a union query. I you can share stuff we need to know
then someone can provide a more specific response.

 

[Guest]

I have three tables:

Employee table which contains employee name and work group (A,B,C,D)
Attendance table which contains employee name, date and vacation code
Schedule table which contains the date, shift1, shift2, shift3 (where the
work group (A,B,C,D) is assigned to work a specific shift)

How do I join the information so that you have the established work schedule
in the schedule table but if a person is on vacation in the Attendance table
the work schedule is overrided with the vacation information for that
employee for that day?

 

[Guest]

I wouldn't go any further without normalizing the Schedule table to fields
like:
tblSchedule
===========
SchedDate
ShiftNumber
WorkGroup

This would allow you to join the Employee table and outer join to the
attendance table.

BTW Name and date are not good names for fields. Check
http://www.allenbrowne.com/AppIssueBadWord.html.