Calculate fields

[StarBuck99]

Many thanks in advanced for your help, & here is my problems:

I have 3 Calculate fields A,B and C:

Field A in table (1)

Fields B,C in table (2)

Both table have common relationship field

--------

How do I create function or formular to perform the following task:

Calculate Value of field A (table1) = Sum of field B(table2) (with condition that when the field C in (table2) equal to blank value) (the calculation only records that have no value in field C)

Edited August 3, 2006 by Guest

[sbg2]

In table 2 create a new unstored calc:

MyNewCalc = If(IsEmpty©;

and then in table 1

A = Sum(MyRelationshipToTableB::MyNewCalc)

[StarBuck99]

Thanks sbg2

It's working great