Reports not showing all data

  • Thread starter Thread starter murrell
  • Start date Start date
M

murrell

I'd like to run a weekly report showing all employees, the amount o
overtime worked and the amount of overtime refused for that particula
week - even if the employee has 0 hours worked or refused. The proble
is that those employees for whom no data was entered in that particula
week do not show up on the report. How do I get around this withou
entering "0" for those employees for that week?

The data is stored in a list and the report accesses it through
query. If there is no data for that employee for that week, the quer
does not pick them up. Is there some way to automatically populate th
list with zeroes for each employee who does not have data entered?

Thanks for your help
 
Murrell,

Open the query the report is based on in design view, and change the join
type between the Employees table and the Overtime table to a right-sided one
(i.e. the line must become an arrow pointing to the Overtime table). Do this
by double-clicking on the line and selectinf the option "Include all records
from 'Employees' and onlythose records from 'Overtime' where the joined
fields are equal" (of course the table names will be the actual ones, not my
hypothetical ones). This will do the trick.

HTH,
Nikos
 
Back
Top