Sum

M

Martin

Okay, I've received some great tips, but I have one more
problem, my table looks something like this,

ID LastName FirstName DaysSuspend
123 Walter Roger 1
123 Walter Roger 3

What I would like to happen if possible, I would like to
sum up the DaysSuspend field and streamline the duplicate
records to look something like this,

ID LastName FirstName DaysSuspend
123 Walter Roger 4

Your Help is appreciated,
Martin
 
S

Steve Schapel

Martin,

This is a Totals Query. If you use the query design view, make a new
query, and include your 4 fields as you showed them. Make it a Totals
Query (select Totals from the View menu). Leave 'Group By' in the
Totals row of the query design grid for the first 3 columns, and put Sum
in the Totals row of the DatsSuspend field.
 
D

Duane Hookom

Just create a query and click on the sigma (backwards 3). Add all the fields
to the grid and set the DaySuspend to Sum rather than Group By.
 
H

Hwylie

Group By on ID, lastname, firstname and sum DaysSuspend.
Tthis should produce the form of data you want.
 
Top