Query to combine two rows according to criteria

[TomYC]

Here is sample data:
Dept JobCat RegFTE Overtime PerDiem
101 RN 1.0 0.5
101 RN 0.75

I want a query to combine these two records into one:
101 RN 1.0 0.5 0.75

As I have many departments, I believe that is my criteria, along with Job Cat. Indeed, for Each Dept I have two records with RN as JobCat, and I want to end up with one RN JobCat record, with data in all three other columns.

What is the name and structure of the query that I need?
Thanks,
TomY

 

[dhookom]

This is a simple totals query that groups by a couple columns and sums others.

Duane
Hook'D on Access
MS Access MVP