how do I combine records in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My database has a field for "Dept Number". Then, there are fields for
entries for employees who are either Active or Terminated. I want the report
to Show the Dept Number once, and then show the sum of either the Active or
Terminated employess.

So far, it will show the Dept. Number each time, then an entry for either
Active or Terminated:

Dept. 100 1 2
Dept. 100 1

and so on. I want it to show

Dept. 100 85 10

Can anyone help me?
 
Hi,
You need to create a totals query and base your report on it.
Create a new query in design view, select dept number, active and term
columns in the query grid. Click on the Totals button. You should see group
by for all 3 columns. Leave the group by for dept number, select sum for
active and term columns. This should give you what you want.
 
Back
Top