I am very new in this and i am struggling with this....
can anyone help...
what i am trying to do is get on a report , vendor, qfill, Countofqfill
but i keep getting repeated qfill, instead of the list of qfill multiplied by
OrderQty.
e,g. what i am getting in Query2......Vendor, OrderNo, qFill, CountOfqFill
SP 001
ptt1 1
SP 001
ptt1 2
SP 001
ptt2 1
what i want is...... SP 001
ptt1 3
SP 001
ptt2 1
Query1
SELECT qrAllItems.Vendor, qrAllItems.OrderNo, qrAllItems.OrderQty, qrAllItems.
qFill, Count(qrAllItems.qFill) AS [Count]
FROM qrAllItems
GROUP BY qrAllItems.Vendor, qrAllItems.OrderNo, qrAllItems.OrderQty,
qrAllItems.qFill
HAVING (((qrAllItems.Vendor)="Foamex-Fab"));
Query2
SELECT [qrAllItemsCountFX-Fa].Vendor, [qrAllItemsCountFX-Fa].OrderNo,
[qrAllItemsCountFX-Fa].qFill, [Count]*[OrderQty] AS CountOfqFill
FROM [qrAllItemsCountFX-Fa]
GROUP BY [qrAllItemsCountFX-Fa].Vendor, [qrAllItemsCountFX-Fa].OrderNo,
[qrAllItemsCountFX-Fa].qFill, [Count]*[OrderQty];
--
Message posted via http://www.accessmonster.com