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

--
Build a little, test a little.


"jfire" wrote:

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
to show all employee's on the same form as they check in. I have done query's
subforms showing the ID but will only refresh if I close the form then reopen.
This is on a single PC. Using Access 2007 I'm at a loss
I have;
Employee_Info Table
Date_Time_IN Query,
Date_Time_IN Table,
Date_Time_OUT Table

.