File Maker Pro 9 selecting records

[alf1965]

hello I hope someone out there can help. I have a table that has a date field and a quantity field. I have another table that has a field named test. What I want to do is make test into a calculated field and sum all the quantities from the table holding quantity field but only for those quantities in which the date field = 10/13/2008.
How do I write this calculation? I have tried everything that I can think of and Im sure Im missing something but nothing has worked for me yet. Any help would be appreciated.
Here is an example of what I am trying to do:

Table 1
row 1
date field: 10/13/2008
qty field: 1
row 2
date field: 10/14/2008
qty field: 1
row 3
date field: 10/13/2008
qty field: 1

Table 2
field test will display 2 (there are 2 items in table 1 that equal 10/13/2008 and number 2 represents the sum of all the quantity fields where the date field - 10/13/2008

 

[gmannatl]

Is there a reason that you need the value in a seperate table?? If so it can be done, but to do this all you need is a summary field in the main table that is the total of the qty field. Then all you need to do is filter the table and the summary field will total automatically. Combine this with some scripting and you can accomplish whatever you need including moving this value to a new table if desired.