talkiechick
Registered User.
- Local time
- Today, 08:26
- Joined
- Apr 15, 2010
- Messages
- 59
So my query is set up as so.
Broker_Descrp (Table Field)
Balance (Sum of a Table Field)
Tier 1 % (Expression)
Description (Expression - IIF Statement)
Well my Description expression basically is showing the actual broker description of the balance is over 1,000,000 but if it is below it shows 'Other-Broker'. When i generate the query it shows rows and rows of 'Other-Broker' I would like the query to sum all the Other-broker's together and keep as one row of data instead of many.
Can someone please help me to accomplish this? Also i cannot use a report to show the data because I am linking the query to an excel file for charting purposes.
Broker_Descrp (Table Field)
Balance (Sum of a Table Field)
Tier 1 % (Expression)
Description (Expression - IIF Statement)
Well my Description expression basically is showing the actual broker description of the balance is over 1,000,000 but if it is below it shows 'Other-Broker'. When i generate the query it shows rows and rows of 'Other-Broker' I would like the query to sum all the Other-broker's together and keep as one row of data instead of many.
Can someone please help me to accomplish this? Also i cannot use a report to show the data because I am linking the query to an excel file for charting purposes.