Design of Payroll Report (Gross Pay >=$25)

[Rita]

I'm having some trouble creating a report. Clients do piece rate work or get
paid hourly. They're guaranteed an income so the formula also checks and
supplies a subsidy if needed.

Gross pay is calculated on the job code entered (determining if it's a piece
rate rate or hourly wage). Several different jobs could be done for one day.
To run payroll, a "Pay Period Ending" date is entered (each record contains a
"Pay Period Ending Date") and the query pulls all records for the client.
It's a simple report showing gross pay for each job and then a total "Gross
Pay" for pay period.

My payroll forms/reports all work.I had a request to view clients receiving
$25 or higher for gross pay. I'm not sure how to sum the gross pay to check
for >=$25. My thought is to put the payroll information into a subreport and
then pull in just client with total gross pay >=$25, but I don't know how to
do this.

THANKS for any suggestions!

 

[Evi]

Use a Totals query grouped by Client and PayPeriodEnding. Filter the query
as you stated. Ensure this query contains the PayPeriod Ending date if that
is how your main report is grouped.


In Design View of the report where you want to see this sub, drag the closed
query onto the report grid.
If your main report is grouped by PayPeriod you may want to link the 2
reports by this feild and drag it into the PayPeriod Group Footer.

If you need an overall list, ignoring the payperiod, then don't link the
subreport to the main one, just put it in the main report's header or footer
and Omit the PayPeriod from the Totals query

Evi