I have a query which queries a table of employees clock in/out information. What we are wanting to do is display to the screen who is clock in for the day and number of hours worked up until the query has ran.
The query we have works just fine but I need to display it properly.
Employee1 Time1 Employee24 Time24 Employee50 Time50
Employee2 Time2 Employee25 Time25 etc
Employee3 Time3 etc
etc until the bottom
of the screen/form then
start a new column on the
I know you can do a report but what we want to do is display this information on a monitor and update the
display every 15 minutes. Can anyone guide me if Access can do this? I know you can do a single column list with a form but can you do multiple columns on form of the same fields? I hope that I have explained this well enough.