sum qty in form from a different table

[steve111]

hi,

I have a table called ( purchasing ) I also have a form called ( stock )
I purchase parts from stock and those quanities goes into the table ( purchasing )
is it possible to create a text box in the form ( stock) that looks at all the table purchasing and sums up the qtyreqd for the part in stock

I have tried = sum([purchasing]![qtyreqd]) but just get an error
any help appreciated
thanks
steve

 

[pr2-eugin]

Lookup on DSum method.

 

[steve111]

Hi Paul,

I have tired but failed , I have attached a sample data base

you will see 2 tables and one form
the table supplier details is what is purchased and it you look at the first line you will see a qty reqr of 6 and it repeats again at the bottom for another 3 for the same material

in the form stocklist I want the qty 9 going against the material, if not material bought just show "0"

thanks
steve

 

[CazB]

I only see one table: stocklist ?

 

[steve111]

hi ,

sorry it was hidden ,

late at night in china nearly asleep

steve