In access the sql statement works fine, however i reciently changed these tables to MSSQL and it will not work.
SELECT Sum([CashSaleyn]=1) AS totalincome
Message is incorrect syntex or somthing
The cashsaleyn is set as a bit, should i change it? (in access it was a yn)
or is there another way