Hi. I have a table tblAttend: key [autonumber] *key date [date/time] emp_no [number] in [date/time] out [date/time] and table tblEmpl_list emp_no [number] *key name [text] and relationship: tblAttend.emp_no -- tblEmpl_list.emp_no Table tblAttend contains only employees who clocked in/out that day, but the full list of employees is in tblEmpl_list. I want to create a query which will set the date in first column which will be max date in tblAttend (date must be in all rows) and then will show e.g. Empl_no, in, out what ever... I know how to make this query, just have problems with setting max date in first column for all records. Any suggestions? Thanks for help.