If its fairly simple, like you've described, you could use the table directly or a query, no biggie. But you're on the right track with sub-report. Base the main report on the main info, make sure you have the EmpID on that report. Call this one rpt-MainWhatever. Then create a second report with the secondary info, the EmpID needs to be in this report also for linking purposes. I usually hide this field (looking Properties, Visible). Now use the sub-report wizard and put sub-Whatever into the main report. If the EmpID fields are already linked, Access should choose these as the link. And there you have it. One report per employee with all the Absences showing up in a sub-report on the same page.