I'm looking for a way to create family payment invoices. I figure that there is a way with SQL to get a listing of each household name, the amount they owe for dues, and the amount they owe for everything else, just like the banner at the bottom of the check-in page.
Once I have this in a table, I could do a mail merge and create an invoice for each family.
The problem is, I am clueless about SQL. Can anyone point me in the right direction?
Thanks,