This is a small question as I am learning, in my query I have Expr1ebit Field. I just need the sql to write the if the statement
In [Transaction_Activity].Amount>0 enter it in [Debit]
I will be able to write the opposite
What I am doing is related to separating my debits and credits in the Amount column from the [Transaction_Action] table. So in a query I am creating a debit field and a Credit Field. Is this the best way of doing this as well?