I have a report created from Excel to record employee’s time. I am new to
writing SQL so I need some assistance in creating this, if this is the
solution. I have a query for each employee’s time worked for the week, the
report needs to display the employees time for the week, but the fields are
duplicating only one entry down the whole page. My fields on the report are;
left row, Job No / Pay Item / CostCode, and across the page are the days of
the Mon-Sun. under the days of the week are the hours worked each day and
this includes Reg Hours/Overtime and Double time. How can I fix this?
Thanks!