Add the fields if there is a match in access

  • Thread starter Thread starter matrix7410
  • Start date Start date
M

matrix7410

Hello,
I have a table with duplicate row (with certain matching fileds) but
with different dollar amounts. I want to combine the dollar amount if
the member id is the same.

Table: Member
Name ID $
John 1000 $100
John 1000 $500

What I want is
John 1000 $1500

Can someone help?
 
How about using a query and choose Group by ID and Sum on $ (if this is
really your columnheading you should change this to something more
appropriate).

You can set the options by clicking the 'Totals' button in the toolbar from
the query. After you've done that, you can set the group by options in the
querygrid.
 
Back
Top