Totalling question

[Frankf]

Name: Screenshot (1).png  Views: 11  Size: 127.2 KB  ID: 26763" class="thumbnail" style="float:CONFIG" />

How do I total the amount of the branches so Dundee is totalled into one and so is Edinburgh and Glasgow? *edit* total of Edinburgh as one

[CJ_London]

sounds like your query is grouping by more than just the branch field

[Frankf]

oh okay then so how do i total the edinburgh purchase prices? sorry new to this

[CJ_London]

Without a clue as to your field names, types, which tables they are in the best I can suggest is your query should look something like

SELECT Branch, Sum(Purchases) As SumofPurchases
FROM Sales
GROUP BY Branch