Totalling question

[Frankf]

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