×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

File Maker Pro 9 selecting records

File Maker Pro 9 selecting records

File Maker Pro 9 selecting records

(OP)
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



 

RE: File Maker Pro 9 selecting records

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close