I am trying to make a section on the invoice that shows the date of each
payment
I never heard of payments listed on invoice but we all learn something new.

Your invoive should currently have a subreport that list all the line items.
that is how you list the payments also.

In the query for the invoice report add the query for the payment in this
manner within the SQL view --
SELECT tblInvoice.*, qryPayments.*
FROM tblInvoice LEFT JOIN qryPayments ON tblInvoice.OrderID =
qryPayments.OrderID
....

--
Build a little, test a little.


"SummitSeeker" wrote:

Hello all... This question may be in the wrong place and sorry if so...
This delima throwing me for a loop and any help is appreciated.

Our clients make multiple payments for the same order. They may make a
deposit with a Check then pay the balance with a Credit Card.

I am trying to make a section on the invoice that shows the date of each
payment and the last 3 digits of the card used or the check number.

I have a querie that finds all records in the "Payments" table with the same
"OrderID". How can i make a section on the Invoice that will display ony the
payments for the current invoice?

I assume that I need to link the OrderID on the current report but i cannot
figure out how to display the information, especially when there is more than
one payment.

Thanks for the help...
-H-