
July 7th, 2005, 03:11 PM
|
|
Registered User
|
|
Join Date: Jul 2005
Posts: 8
Time spent in forums: 3 h 16 m 31 sec
Reputation Power: 0
|
|
|
parameter query + report
I am wanting to set up a report detailing deliveries from a selected supplier. The report should contain the fields 'number', 'product name', ' cost price', 'qty', and 'total cost' of each product in a delivery.
I am needing a parameter qry and I have set one up containing the fields - 'SupplierID', 'product name', ' cost price', 'qty', and 'total cost'. Should I include DeliveryID? So far the query works on its own but when i produce a report from this query it doesn't.
Also 'total cost' is a calculated field made up from 'cost price' & 'qty'. How is this set up? I've tryed [tblDeliveryDetailsNew]![CostPrice] * [tblDeliveryDetailsNew]![Qty] in the criteria field but it turns into a parameter query.
Are all these queries 'select queries?
|