how can i combne duplicate records in a table by using a query

[Access Newbie looking for help]

I have a query that is pulling data from one talbe. If there are
duplicateds, which there are, How can I combine them? Same customer number,
same name, same revenue code and same service branch-I want to combine
records that share this data or that have identical data

 

[BLTibbs]

Inside the design view on queries, there is a button called 'Totals' and
looks like an odd looking letter E (the math symbol).

Once you click on that button, you will have a new row of data on all of
your fields in the query.

For all of the fields that could have duplicated information that you want
to combine into one row, you need to have the new totals row show "group by".
Then if you want a count of how many of those records are showing, at least
one of your fields needs to have 'count' set in the totals row.

 

[Access Newbie looking for help]

Thank you for your response my current query has group by selected in all of
the fields except the amount field, In the amount field I have sum selected,

I want access see, everything is the same, so combine them and sum the
amounts so the end result is one combined row with a combined total

My data is arranged as follows:

Customer Number, Customer Name, Revenue Code, Servicing District, Servicing
branch, date and amount.

My current query pulls the above data from one talbe and lists everything by
date.


I would like my query to list everything however, when it finds record that
have the same customer number, name, revenue code, servicing district,
servicing branch and date combine those records and add their amounts
togather (even if the amounts are different but everything else is the same)

That way I can see:

for xyz customer, for the month of april I had a total of x dollars.

My current method lists xyz maybe 4 or five times in a given month when the
only difference is just the amount. I hope this makes sense, and I hope you
can help. Thank you for your time.