Dlookup inside a dsum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top