July 10th, 2005, 06:12 AM
|
|
Registered User
|
|
Join Date: Jul 2005
Posts: 8
Time spent in forums: 3 h 16 m 31 sec
Reputation Power: 0
|
|
what is wrong?
I have set up a parameter query that contains a calculated field.
SELECT tblProducts.SupplierID, tblDeliveryDetails.DeliveryID, tblProducts.ProductName, tblDeliveryDetails.CostPrice, tblDeliveryDetails.Qty, tblDeliveryDetails!CostPrice*tblDeliveryDetails!Qt y AS TotalCost
FROM tblProducts INNER JOIN tblDeliveryDetails ON tblProducts.ProductID = tblDeliveryDetails.ProductID
GROUP BY tblProducts.SupplierID, tblDeliveryDetails.DeliveryID, tblProducts.ProductName, tblDeliveryDetails.CostPrice, tblDeliveryDetails.Qty
HAVING (((tblProducts.SupplierID)=[Enter Supplier ID]));
Runing the query is fine, I'm just asked to enter a supplier ID, but when I run a report with this query, I'm also asked for a value for 'total cost'.
Have i set up something wrong?
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
