Help Writing Individual Reports

  • Thread starter Thread starter michael_quackenbush
  • Start date Start date
M

michael_quackenbush

I apologize for this question, but I am forgetting much of my Access
knowledge:

I am trying to generate an individual report to be generated for each
person on my payroll database. This report would have their weekly
pay, as well as a GrandTotal for year to date earnings (summing up the
amounts in the database for each NameID) I currently have two tables
in my database for these records:

Table 1: NameID, LastName, FirstName
Table 2: NameID, FiscalWeek, Amount

I would like a report to be generated for each NameID on a separate
page. I need help on how I need to generate this report, and where
the page break command would appear.

Thanks,
Mike
 
-- UNTESTED --
Use this query --
SELECT [Your Employee Table].NameID, [Your Employee Table]. LastName, [Your
Employee Table]. FirstName, [Your Pay Table]. FiscalWeek, Sum([Your Pay
Table].Amount) AS SumOfAmount
FROM [Your Employee Table] INNER JOIN [Your Pay Table] ON [Your Employee
Table].NameID = [Your Pay Table].NameID
GROUP BY [Your Employee Table].NameID, [Your Employee Table]. LastName,
[Your Employee Table]. FirstName, [Your Pay Table]. FiscalWeek;

Open the report in design view and click on menu VIEW - Sorting and
Grouping. Select NameID and set Group Footer to After Section. Click on
footer and set Force New Page to Yes. Add the field SumOfAmount to the
footer and set Running Sum Property to Over Group.
 
Back
Top