Hi all,

How do i use the Compute statement as in the following example:

(I'm trying to sum up the total bill of all those Vendor who are in the same dept, AR is my table name)

Code:
Select dept, Vendor, TotalBill From AR Group By Dept Order By Dept Compute Sum(TotalBill)

I know this format is wrong somewhere, as in compute should come first or did i miss out any command ? Hope someone can correct me.

Thks a lot.