K
kev100 via AccessMonster.com
I've got 2 tables containing Time Stamped entries on employees.
One table has a mass of entries.........several entries an hour...all in
order by TIME.
The Second table also has Time Stamped entries for employees....but only a
FEW every now and then.....like 2-3 over a five hour period. The only common
element between the 2 is Date and Employee ID
The query would need to reference both tables. Since the TIME is unique
(there will never be a record with the same Time Stamp).....the list would
need to simply show:
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 2)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 2)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
.....in a list...in order by TIME. So......the query results would look
something like:
Login Time1a____Employee ID___Employee Name____
Login Time1b____Employee ID___Employee Name____
Login Time1c____Employee ID___Employee Name____
Login Time1d____Employee ID___Employee Name____
Login Time1e____Employee ID___Employee Name____
Login Time2A____Employee ID___Employee Name____
Login Time1f____Employee ID___Employee Name____
Login Time1g____Employee ID___Employee Name____
Login Time1h____Employee ID___Employee Name____
Login Time1i____Employee ID___Employee Name____
Login Time1j____Employee ID___Employee Name____
Login Time1k____Employee ID___Employee Name____
Login Time2B____Employee ID___Employee Name____
Login Time1j____Employee ID___Employee Name____
Login Time1l____Employee ID___Employee Name____
....etc.
The question is....I'm not sure how to create this query.....since
information from BOTH tables should NOT appear One line.....but on seperate
lines....since the entries are being put in order by TIME.
Hope this makes sense.
Thanks,
Kev
One table has a mass of entries.........several entries an hour...all in
order by TIME.
The Second table also has Time Stamped entries for employees....but only a
FEW every now and then.....like 2-3 over a five hour period. The only common
element between the 2 is Date and Employee ID
The query would need to reference both tables. Since the TIME is unique
(there will never be a record with the same Time Stamp).....the list would
need to simply show:
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 2)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 2)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
Employee Login Time (from table 1) Employee ID (from table 1) Employee
Name (from table 1)
.....in a list...in order by TIME. So......the query results would look
something like:
Login Time1a____Employee ID___Employee Name____
Login Time1b____Employee ID___Employee Name____
Login Time1c____Employee ID___Employee Name____
Login Time1d____Employee ID___Employee Name____
Login Time1e____Employee ID___Employee Name____
Login Time2A____Employee ID___Employee Name____
Login Time1f____Employee ID___Employee Name____
Login Time1g____Employee ID___Employee Name____
Login Time1h____Employee ID___Employee Name____
Login Time1i____Employee ID___Employee Name____
Login Time1j____Employee ID___Employee Name____
Login Time1k____Employee ID___Employee Name____
Login Time2B____Employee ID___Employee Name____
Login Time1j____Employee ID___Employee Name____
Login Time1l____Employee ID___Employee Name____
....etc.
The question is....I'm not sure how to create this query.....since
information from BOTH tables should NOT appear One line.....but on seperate
lines....since the entries are being put in order by TIME.
Hope this makes sense.
Thanks,
Kev