If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
querying unrelated tables
I have two tables - Employee_PunchTime table and Holidays Table. The
PunchTime table contains three fields representing EmployeeID, Time-in and Time-out; and the Holiday table contains two fields representing name of holiday and the date. If the payroll period is 5/31/2010 (Mon) thru 6/4/2010 (Fri) and 5/31/2010 is a paid holiday, I need to create a query that shows punched time and paid holiday on a separate column. On the paid holiday, there would obviously be no Time-In and Time-Out record. It will look something like this: EmpID Date Time-in Time-out Paid Holiday ------- ---- -------- --------- ------------ 1001 5/31/10 Memorial Day 1001 6/01/10 9:00 am 6:00 pm 1001 6/02/10 9:00 am 6:00 pm 1001 6/03/10 9:00 am 6:00 pm 1001 6/02/10 9:00 am 6:00 pm Any suggestions? Thank you. Keith |
Thread Tools | |
Display Modes | |
|
|