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
|
|||
|
|||
ACC2000: dealer order form with last yr qty
I want to print a dealer order form with all products on it. I want the
total of each product the dealer ordered in 2007 to be in a different column next to the product. I am having problems getting the results I want. Here are the tables I have: *=key field - Customer table Fields: o CustomerNumber* - OrderDetail table Fields: o CustomerNumber* o ItemNumber* o QtyPurchased2007 - ItemIndex table Fields: o ItemNumber* o ItemDesc I tried linking the tables various ways using inner and outer joins, and join option 1. Nothing gives me (in the query) all products for a customer. I thought I might start with the ItemIndex table and join like this: ItemIndex!ItemNumber - OrderDetail!ItemNumber, OrderDetail! CustomerNumber - Customer!CustomerNumber But that did not work (I only got items purchased, I need to show all items.) Thank you. |
Thread Tools | |
Display Modes | |
|
|