lookup

[steve111]

hi ,

I have a form called "stocklist2" I also have a table called " allocation"

I want to put a field in the stocklist form that looks for the material in the "allocation" table. sums up the " qty allocated" from that table and returns that value in the stocklist form.
the field in the stocklist form and in the allocation table are both called " material"

thanks
steve

 

[plog]

Sounds like you want to set the control source of your form's field to a DSUM (http://www.techonthenet.com/access/functions/domain/dsum.php)

 

[gemma-the-husky]

note that having domain subtotals built in to a query will not be quick, especially if you have a lot of items to report.

worth testing this carefully to find the most effective solution

 

[plog]

I agree with gemma's non-sequitor.