Who's paid more than 195,-?

[LasseJ]

Hi all

Can someone help a newbie out with this one?:

I have a membership database where each membercard has a portal (related by a ID-No.) which shows what amount of money each member has paid over the years.

I would like to have some kind of calculationfield on each membercard which shows the total of the amount paid by the member in current year.

BUT! Since I'm only interested in the totals whichs exceeds the amount of 195,-, it would be nice if the calculationfield automatically deducts that amount.

Please feel free to ask, if my question is a bit blurry

Regards

Lasse

[Ender]

Since you want to show related records for only the current year, you'll need to add a relationship that includes a criteria limiting to only the current year. You could use a date-range match for this, or use a Membership Year field. In any case, the filter on the parent side should probably be a global (or set of globals) matching to a corresponding field on the child side.

One you get that relationship working, you can then have a calc in the parent side to show the total amount paid for the specified membership year, as well as deduct from the total amount due.