Combining records and adding numeric data together

D

Dr. BOss

I have 4 records for the same person. In one of the columns for each record
I have a different dollar amount in a column. I want to bring this down to
have the person listed once and the dollar amounts totaled. When done I want
the table to look the same except to merge these four records into one with
the total dollar amount of all 4 records.
 
S

Steve Schapel

Dr. Boss,

1. Make a backup copy of your database
2. Make a blank table the same structure as your existing table.
3. Make a query based on your existing table, and include all fields in
the query design grid.
4. Make this into a Totals Query (select Totals from the View menu)
5. Leave 'Group By' in the Totals row of the query design grod for all
fields except the dollar amount field, and in this column change it to Sum.
6. Make this into an Append Query (select Append from the Query menu),
nominate the new table as the table to append to, and check all the
field names in the Append To row of the query design grid.
7. Run this query (click the toolbar button with the red ! icon), and
confirm at the prompts.
8. Delete your existing table from the database.
9. Rename the new table to what the existing table is now called.
 
Top