Aug 10 2009, 11:34 AM
I am a beginner at access so please forgive me if this question has been asked before. I have one table where I have the fields:
I want to combine the duplicates from the BDM field and show the total sold revenue. What is the best way to do that?
Thanks in advance!
Aug 10 2009, 11:36 AM
I would use a totals query...group on the BDM column and sum the [Sold Revenue] column.
Aug 10 2009, 11:46 AM
I tried that but it brings duplicate names in the BDM field. I want to combine those names and have a total of their revenue from the sold revenue field.
Thanks for the quick response!
Aug 10 2009, 11:49 AM
I guess I don't understand what you mean when you say...
I want to combine those names...
Aug 10 2009, 12:53 PM
You need to be careful. A totals query will give you one row for each different combination of Group By values it finds in its recordset.
To Group By on BDM field all by itself it must be the only field with Group By in its Totals cell.
If you need other fields then develop a new query that joins the totals query back to the table on the BDM field.
Aug 10 2009, 04:35 PM
Thanks Frank and Kristen. Got it!
Aug 11 2009, 08:42 AM
You're welcome. Kristen and I are glad we could help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here