Pulling Data from a table that not related to the form

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

Guest

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.
 
Use DSum()

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