KARL DEWEY wrote:
Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.

I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need
[quoted text clipped - 8 lines]

.
SELECT Date_Time_In.AT_Number, Resident_Info.L_Name, Resident_Info.F_Name,
Resident_Info.Unit_Number, Date_Time_In.[Date+Time_In]
FROM Resident_Info INNER JOIN Date_Time_In ON Resident_Info.At_Number =
Date_Time_In.AT_Number
ORDER BY Date_Time_In.[Date+Time_In] DESC;

--
Message posted via http://www.accessmonster.com