I was wondering if it was possible to "add" together all the numbers contained in a table based on the "company name" I ask this because the company have more than one phone per a business and need to be added up and sorted dynamicly. from highest to lowest.
An example of my table is attached
So what im trying to do is get the following
Company TOTAL SPEND
ANNA Norris £178
PETER jones £100
As you can see it adds up all fields where Anna norris is the company name. as totals it.. so this would ADD both mobile number spends together. Because two people have phones in One company.
It then would need be orderd from highest to lowest?
Is This possible with a query??
if not is there any other ways you can think of??
All help is appricated.