I have to display all fields of my table with a break based on the first two digits of the account number and subtotal of the account balance field at each break.
I've been trying for while now but I ran out of ideas on how to write it. And I keep get this error message everytime I execute.
FROM tblChartofAccounts AS SubTotalBalance
WHERE account Like '10%','11%','12%','13%'
SELECT SUM (Balance) AS SubTotalBalance FROM tblChartofAccounts
And the error code is
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ','.
Any suggestions I would appreciate!
View Complete Post