combining two tables into one

[Dragon_Silveroak]

I have 2 tables

tbl 1
Emp#
Date
Time1

Tbl 2
Emp#
Date
Time2

I want to create a table or query that returns
Emp#, Date, 1st Time1, 1st Time2
Emp#, Date 2ed Time1, 2ed Time2
and so on.

Any ideas would be very helpful, Thanks in advance.
DS

 

[[MVP] S.Clark]

I don't understand why there are two tables, but in order to find the 1st or
2nd of a series, I would think that you would first need to combine all the
values into one source.

 

[Dragon_Silveroak]

Ok, hold on to your chair...
Im building a database to function as a timeclock for the employees of my
company.
When they enter their Emp# in the main form the data base punches the
current date and then the current time based on their last punch (i.e. if the
last punch put the current time in the O field the current punch will put the
current time in the I field) but in a new record. What I get is a record set
where each record contains the Emp#, Date and I or O but not both.

What I was hoping to do, is list That info sorted in 2 seperate sets and
then say...
Put the 1st I with the 1st O and the 2ed I with the 2ed O.

Please help, Im open to suggestions.
DS

 

[NonVBATwit]

I'm not exactley sure of what you want but would a UNION qry do the job?