this is an update query that i've created to transfer the information from
the a select query to a table......why it doesnt work...can u spot it please..
..it gives an error of too complex....

UPDATE qrAllItemsCountFXFab LEFT JOIN tblEditablePO ON qrAllItemsCountFXFab.
OrderNo = tblEditablePO.OrderNo SET tblEditablePO.OrderNo =
[qrAllItemsCountFXFab].[OrderNo], tblEditablePO.Vendor =
[qrAllItemsCountFXFab].[Vendor], tblEditablePO.qFill = [qrAllItemsCountFXFab].
[qFill], tblEditablePO.OrderQty = [qrAllItemsCountFXFab].[OrderQty],
tblEditablePO.Type = [qrAllItemsCountFXFab].[Type], tblEditablePO.Cost = DSum
("[QfillCost]*[OrderQty]","qrAllItems","[OrderNo] =" & [OrderNo]);


bigwillno2 wrote:
Sounds like a plan...what should i do, create a update query that would
update the information in this new table with the information in the query
(query that contains the information that the report has) by a click of a
button or it's there a way i could edit the information on this query on the
fly.

I still don't know what "substract the inventory materials from the POs
before they send it to thier material vendors" has to do with a report.
[quoted text clipped - 6 lines]
Hello, can anyone direct me on how to make changes to prices on a report on
the fly.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1