Pulling Data from a table that not related to the form

M

MOURRA

I have a form called Product Subform that contains a field called UnitsSold.
I would like this to pull data from a table called Inventory Transactions. I
need to have the total sum of the Quantity column in the table.

Can someone please help me.
 
A

Allen Browne

Use DSum()

Example:
=DSum("UnitsSold", "Inventory Transactions", "ProductID = " &
Nz([ProductID], 0))
 
Top