Hi all, Have this small question about COMPUTE. As per below is the code that i used but it appears a syntax error(missing operator).

The code: ( EXPORT_ACC is my table)

Adodc1.recodsource = "Select VENDOR, GP, PEE From EXPORT_ACC WHERE VENDOR = 'NEWCASTL' COMPUTE(SUM(TOTALBILL)) BY Dept"

Adodc1.Refresh
.
.
.

I had double check all my fields, but the error this appears.

Pls give me some advices . Thks. If you got better command pls show me . Thks again.