I'm trying to create an invoicing report that involves a one-to-many relationship. The report runs fine as long as there are records in the Transactions table. I have the Client table filtered to Balance # 0. I want the form printed if there is a balance, even if no charges or payments were posted for the period.
Any thoughts?
Thanks.