W
Will G
Goal: generate a purchase order report that contains vendor, item, and
quantity. this is done as items are being selected from listbox bellow.
i have.......listbox......sched that has multiple column
OrderNo|RequiredDate|ModelNumer|Description|OrderQty
46001 05/04/07 a33m any 1
40006 05/04/07 a33m any 2
for every model number there are items that need to be ordered from vendors.
Here is where the Purchase Order report is generated. as i select from the
list box above, i click a button that prints the Purchase Order Report for
every selection from the listbox.
Problem: example above shows two different OrderNo of the same ModelNumber,
therefore, multiple of the same items will comeup for order from vendors
since is a multiselect list box.
i do get the items amounts right on the Purchase Order Report, the only thing
that i am having problem with is that same items are repeating.
i have two query that i have......
1.....includes OrderNo, prints the report, but contains repeating items...
since there could be multiple order of the same ModelNum
SELECT qrAllItems.Vendor, qrAllItems.OrderNo, qrAllItems.Type, qrAllItems.
qFill, Sum(qrAllItems.OrderQty) AS CountOfqFill
FROM qrAllItems
GROUP BY qrAllItems.Vendor, qrAllItems.OrderNo, qrAllItems.Type, qrAllItems.
qFill
HAVING (((qrAllItems.Vendor)="Foamex-Fab"));
2......does not Include OrderNo, contains the right items and the right
quantity, but doesnt have OrderNo, therefore, doesnt print the report since
the strWhere is OrderNo.....
quantity. this is done as items are being selected from listbox bellow.
i have.......listbox......sched that has multiple column
OrderNo|RequiredDate|ModelNumer|Description|OrderQty
46001 05/04/07 a33m any 1
40006 05/04/07 a33m any 2
for every model number there are items that need to be ordered from vendors.
Here is where the Purchase Order report is generated. as i select from the
list box above, i click a button that prints the Purchase Order Report for
every selection from the listbox.
Problem: example above shows two different OrderNo of the same ModelNumber,
therefore, multiple of the same items will comeup for order from vendors
since is a multiselect list box.
i do get the items amounts right on the Purchase Order Report, the only thing
that i am having problem with is that same items are repeating.
i have two query that i have......
1.....includes OrderNo, prints the report, but contains repeating items...
since there could be multiple order of the same ModelNum
SELECT qrAllItems.Vendor, qrAllItems.OrderNo, qrAllItems.Type, qrAllItems.
qFill, Sum(qrAllItems.OrderQty) AS CountOfqFill
FROM qrAllItems
GROUP BY qrAllItems.Vendor, qrAllItems.OrderNo, qrAllItems.Type, qrAllItems.
qFill
HAVING (((qrAllItems.Vendor)="Foamex-Fab"));
2......does not Include OrderNo, contains the right items and the right
quantity, but doesnt have OrderNo, therefore, doesnt print the report since
the strWhere is OrderNo.....