Okay, now I got them all to show up on the invoice report by editing the
joins (thanks!), but when they show up, the ones that didn't have payments
are just blank for the final balance instead of giving the amount due.

Nancy


The invoice report's record source query probably has an
Inner Join between the two tables when it needs to be an
outer join. Rght click on the line connecting the patient
table to the payments table and select Edit Relationship
from the little pop up menu. Then select the option with
Show all patient records and any matching payment records.

--
Marsh
MVP [MS Access]