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.
BEGIN TRANSACTION
SELECT account,AcctDescription,ShortDescription,Store,AcctType,Balance
FROM tblChartofAccounts AS SubTotalBalance
WHERE account Like '10%','11%','12%','13%'
SELECT SUM (Balance) AS SubTotalBalance FROM tblChartofAccounts
COMMIT
And the error code is
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ','.
Any suggestions I would appreciate!
thank you
View Complete Post