hello,
ok...here's the wrap: A user inputs a date range and, using that date range, my query scans a table for transactions within the range. Some transactions might have the same company name for it. What I need is the sum of another field, commissions, for each different company name so that I can make a report arranged by the commission totals in descending order by company names. I guess the main question would be: how would i be able to get a commission total for each distinctive company? thanks a lot! =P
ok...here's the wrap: A user inputs a date range and, using that date range, my query scans a table for transactions within the range. Some transactions might have the same company name for it. What I need is the sum of another field, commissions, for each different company name so that I can make a report arranged by the commission totals in descending order by company names. I guess the main question would be: how would i be able to get a commission total for each distinctive company? thanks a lot! =P