If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple Queries...?
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- |
Thread Tools | |
Display Modes | |
|
|