Hi, everybody. I been trying to make this work, but nothing seems to work. I wish i was a filemaker expert.. What i have is 4 fields. Dept, Amount, and Summary by A.M., and Summary by P.C..

[Nestor]

Hi, everybody. I been trying to make this work, but nothing seems to work. I wish i was a filemaker expert.. :

What i have is 4 fields. Dept, Amount, and Summary by A.M., and Summary by P.C..

In "dept" i have a drown down list (A.M. and P.C.) (with 6 repetitions) 1 of 1, 2 of 2, and so forth

in "ammount" is a number field with 6 repetition

So in essence "dept" and "amount" have a 1 to 1 ratio.

The "summary by A.M.", and the "summary by P.C.".

What i want for these two fields, and i CAN't make it work is to have a summary.

For example i want Summary by A.M. to give me the sum of all the "ammounts" that have the "dept" A.M.

And i want the same thing for Summary by P.C.

I hope this makes sense, and that its duable.

Thanks in advance.