Sum

  • Thread starter Thread starter Martin
  • Start date Start date
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
 
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.
 
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.
 
Group By on ID, lastname, firstname and sum DaysSuspend.
Tthis should produce the form of data you want.
 
Back
Top