Recent content by markramos

this is not a homework problem. i just created that query i needed help with. that was for our system. an accounting system. i never ask help on other developers for assignments.

Thank you very much for the information. I learned alot from that. Our instructors did not teach us about those two functions. Such a great big help sir! Thank you very much! Problem solved!

it worked well. Thanks for the reply. Can i ask one more favor? Can you explain what you did? especially on the IIFs.. thanks

i have created a query that solves for the difference of the debit and credit of the accounts receivables of a certain member or person.. SELECT DISTINCT ( (SELECT SUM(Amount) FROM (SELECT tblJournal.Amount, tblJournal.AccountAction FROM tblJournal WHERE JournalEntryNumber IN ( SELECT...