I have this query in SQL Server:
SELECT Dated, AccountID, AccountName, Rate,
case (when (Credit-Debit) > 0 then Credit-Debit END) as Credit,
case (when (Credit-Debit) < 0 then Credit-Debit END) as Debit,
Balance
FROM TempTrallBalance
How can I convert it to Access syntax?