Dlookup inside a dsum

[andy stanford-jason]

i am trying to calculate the weight of an order, it goes something like this:

Weight = DSum("[ProductID]*[ProductOrderUnitQuantity]", "ProductOrder",
"[OrderID]=" & [ID])

but i dont want the sum to contain productID instead i want it to say
ProductWeight. the problem i am haing is that the product weight is in a
table called Product and i dont know how to get at that information.

thanks

 

[Alex Dybenko]

Hi,
make a new query, where you join tables productorder and product and
multiply ProductOrderUnitQuantity and product weight . then DSum() this new
field on new query

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com