points inactive shown only

[yessir]

I have this db and on the points form it shows the total points that a person has...

I have a field in the points table that refers to the points being active or not (yes/no) no means active yes means inactive...

I want the total on the frm_points page to show total for ONLY those which are active = no..

i could really ise some help!

thanks
~

 

[scottfarcus]

change the control source of the point_total text box to:

=IIf(IsNull([Combo15]),"",Nz(DSum("Points","tbl_points","ChildID = " & [Combo15] & " AND Active = 0"))+[text19])

 

[yessir]

thanks again!