I'm trying to display some data from a MS Access database to a data report. It was successful, unfortunately, I need to display it in the format below:
emp_name date remarks
date remarks
date remarks
date remarks
emp_name date remarks
date remarks
date remarks
date remarks
....
and here's the SQL command I'm trying to use:
SELECT Employee_Table.emp_name, date, remarks FROM Employee_Table INNER JOIN Login_Table ON Employee_Table.emp_id=Login_Table.emp_id
can anybody please help me?
thanks.