A Alex H Mar 23, 2005 #1 Hi - is it possible in the header section of a group, to sum field1 where the value of field2 = 1? Thanks A
Hi - is it possible in the header section of a group, to sum field1 where the value of field2 = 1? Thanks A
F fredg Mar 23, 2005 #2 Hi - is it possible in the header section of a group, to sum field1 where the value of field2 = 1? Thanks A Click to expand... if I understand your question properly, then, in an unbound control's control source: =Sum(IIf([Field2]=1,[Field1],0))
Hi - is it possible in the header section of a group, to sum field1 where the value of field2 = 1? Thanks A Click to expand... if I understand your question properly, then, in an unbound control's control source: =Sum(IIf([Field2]=1,[Field1],0))