i am trying to execute a query that

[dulla]

i am trying to execute a query that sums two fields in a table of quarterly data.

field one: the sum of all 4 quarters for [employees that left that quarter] for a particular year. so i need to sum this field for all 4 quarters.

field two: the sum of [total employees] that are only in quarter 4. so i need to sum all of the quarters that are labeled '4' for all clients that submit their employee data.

In one query, i can get either one of the two fields to display, but not both at the same time. i need to both to somehow come up so i can add the together. would i need a join query? thanks

ameen

 

[megaamp]

In each field use
IIf(test,[Quarterly value],0)

In field one test for "[employees that left that quarter] for a particular year"

In field two test for "[total employees] that are only in quarter 4"