Consolidating Same Clinic Names

[avv]

Hello,

I am working on a project for work. I have my excel document imported. Now I have to join the same clinic names together.



For example I have three separate orders for "ABC Clinic". How do I join them in one so the total sales is combined as well.

Thank you for your help!!! I have to solve this soon to turn in!

[JoeM]

Create an Aggregate (Totals) Query.

Just to the following steps to do this:
- Create a new query based on your table
- Add the "Clinic Name" and "Sales" fields to this query, and nothing else
- Click on the Totals button in the Query Builder (looks like a Sigma) - this will add a Totals row with the phrase "Group By" under both fields
- Change the "Group By" value to "Sum" under the "Sales" column
- View your results

[ranman256]

usu, an order is 1 record, and the other table ,tOrderDetails , have several detail recs. (not knowing your layout)
so the query usu:
select both the tOrder table and tOrderDetail tables.
Join on OrderID field.

If yours is like this, then the CLINIC name should also be part of tOrder table.
Once you make Q1 to see ALL records,
Make Q2 to sum them all from Q1.