Sum help needed

[jeo]

I need some help figuring out how to sum all values for a variable based on another variable.
Here is an example: I have a Unit (Programming, Consulting, Training) and I have a variable called FTE which tells me how much that particular Unit is used.
All I want to see on the form is Unit and FTE (Summed) for that particular Unit.
Is there a way to do that?
I created a variable: SumFTE: nz([FTE1]) and that sums the FTE, now how do I make it Unit specific?
Thanks.

 

[jeo]

I got it figured out.
I used the Group By in the query and it worked excellent.
Thank you for the efforts.
Always appreciate everyones help!