Reply to thread

Message: [QUOTE="Marshall Barton, post: 2343084"] SELECT R.Dept, R.CardNo. R.[Name], R.LogDate, R.LogTime As InTime, S.LogTime As OutTime FROM tblTimeLog As R Left Join tblTimeLog As S ON R.CardNo = S.CardNo UNION ALL SELECT S.Dept, S.CardNo. S.[Name], S.LogDate, Null, S.LogTime FROM tblTimeLog As S Left Join tblTimeLog As R ON S.CardNo = R.CardNo WHERE R.CardNo Is Null You did not explain why you want to create a new table. It is usually sufficient to just use a query like the above instead of another table, but if it really is necessary just change use the query menu to change it to a make table query. [/QUOTE]