I know that what I have been asked to do is not that difficult. I am just stuck and can't figure it out. So I am sure the people here at Access World can help me.
I have 2 related tables:
Payments:
InvoiceNum
Date
PaidAmount (Note can be positive or negative amount)
VendorID - links to...