Multiple records

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hello I currently have a table that looks like this:
ID LastName FirstName NoSuspension
123 MICHAELS DAVID
123 MICHAELS DAVID
456 ROGERS SAM
456 ROGERS SAM
888 WALTON LENNY

What I would like to accomplish is this;
ID LastName FirstName NoSuspension
123 MICHAELS DAVID 2
456 ROGERS SAM 2
888 WALTON LENNY 1

Unfortunately I get a text file emailed to me this way
every month. Is there a way I can streamline it to where
it sums the multiple records and adds them in the
NoSuspension field? As of right now I am entering the
NoSuspension manually.
Help,
Martin
 
Hello I currently have a table that looks like this:
ID LastName FirstName NoSuspension
123 MICHAELS DAVID
123 MICHAELS DAVID
456 ROGERS SAM
456 ROGERS SAM
888 WALTON LENNY

What I would like to accomplish is this;
ID LastName FirstName NoSuspension
123 MICHAELS DAVID 2
456 ROGERS SAM 2
888 WALTON LENNY 1

Unfortunately I get a text file emailed to me this way
every month. Is there a way I can streamline it to where
it sums the multiple records and adds them in the
NoSuspension field? As of right now I am entering the
NoSuspension manually.
Help,
Martin
Click to expand...

A Totals query will do this very readily.

Create a Query based on the table, selecting only the ID, LastName and
FirstName fields. Add the ID field *again*.

Change it to a Totals query by clicking the Greek Sigma icon (looks
like a sideways W). Leave the default GroupBy on the first three
fields and change it to Count on the added one; you can change the
label on the field to NoSuspension - Access will call it CountOfID but
you can just overtype that.
 
Back
Top