Sums in a Query

[sara82]

I have a query which shows employee Totals it has the following fields:

Emp: [EmployeeLastName] & ", " & [EmployeeFirstName]

LogHours
Total: Sum

TotalWorkedPgs
Total: Sum

WorkDays: Sum([LogHours])/8

AvgPgs: (Sum([TotalWorkedPgs]))/(Sum([LogHours])/8)

JobType

JobEffort

-----

Job Effort is a has 3 values: My Corrections, Others, YOYO

I would like to know the:
Sum of TotalWorkedPgs when Job Effort is My Corrections
Sum of TotalWorkedPgs when Job Effort is Others
Sum of TotalWorkedPgs when Job Effort is YOYO

Because I need all of this information on a report.

Any help will be appreciated.

Thanks

 

[sara82]

Thank you Pat I will try your suggestion right now and let you know how it goes.

 

[sara82]

I'm sorry Pat, but I'm not able to recreate the example that you provided me.

If I needed something like this: Job Effort "My Corrections", Sum(TotalWorkedPgs)
I know that is not the right syntax as I don't know how to put it in the correct syntax.

How would I do this in Design View of the query

 

[sara82]

Thank you Pat, it's what I needed