Pulling Data from a table that not related to the form

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.
 
A

Allen Browne

Use DSum()

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching for partial match on a referenced table? 2
Access Updating inventory levels 0
Assigning the value of a calculated field on a form to a table fie 1
Displaying records with a zero value 6
Pulling data from a linked SQL table 2
Data entry for a table from a form 1
Access Click in Table to Open Form 0
Pls Help - default value in a subform 1

Top