Hi all,
Have a report that lists money from clients into an account from two separate tables (two different classes of clients).
Created a report, however, I want to remove any client when the sum of their balance is zero. I also want to display only the sum of money instead of individual records. Currently it displays all records (in and out). The report has the grand total listed in the footer.
It has been a while since I have inserted any coding into the database, and will need to know where and what.
Much appreciated.