query from tables with diff structure

A

Alex

Hi,
I have one employee table with employeeID as a primary key and availability
days as follows:
EmpID MonAM MonPM TueAM TuePM WedAM
1 0 1 o 1 0
2 1 0 1 0 1
....
and another table with time preferences as follows:
EmpID PrefNum StartTime
1 1 12:00:00AM
1 2 01:00:00AM
1 3 03:00:00AM
....
I'd need to get a one row per employee as for the first table.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Guru's, Please help Sequence Numbers in Query 1
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
Update Query based on Difference in time 3
[Ender Date]+1 Query Problem 2
Need Help with Counting of Sequence for worked hours 1
Need Help With Make Table Query 2
How To Call A SQL Stored Procedure From Access 1
Counts number of entries per day in query 4

Top