MiltonSnider
Programmer
Hello I would like to assign the value of a query, this is a select query with a single value, to the control of a textbox. I tried typing [query].[linetotal] as the control but I get #Name?
the query is as follows and works as long as the form is open, since criteria comes from the form.
SELECT (Sum([Quantity]*[UnitPrice]) AS LineTotal
FROM BOC INNER JOIN ((OrgCodes INNER JOIN Orders ON OrgCodes.OrgcodeID = Orders.OrgCodeID) INNER JOIN OrderDetail ON Orders.OrderID = OrderDetail.OrderID) ON BOC.BOC = Orders.BOC)
WHERE (((OrgCodes.OrgcodeID)=[Forms]![AO15]![Borg]) AND ((BOC.BOC)=[Forms]![AO15]![Combo135]))
thanks
Milton
miltonsnider@yahoo.com
the query is as follows and works as long as the form is open, since criteria comes from the form.
SELECT (Sum([Quantity]*[UnitPrice]) AS LineTotal
FROM BOC INNER JOIN ((OrgCodes INNER JOIN Orders ON OrgCodes.OrgcodeID = Orders.OrgCodeID) INNER JOIN OrderDetail ON Orders.OrderID = OrderDetail.OrderID) ON BOC.BOC = Orders.BOC)
WHERE (((OrgCodes.OrgcodeID)=[Forms]![AO15]![Borg]) AND ((BOC.BOC)=[Forms]![AO15]![Combo135]))
thanks
Milton
miltonsnider@yahoo.com