I'm hoping that someone can steer me in the right direction as I'm still trying to figure out how Access works. I have created a report and need to insert a formula to sum a particular text box (which has this formula in it: IIf(Count([Job Req No])>1,IIf((Sum(IIf([Race]<>"White",1,0)))>0,1,0),0)) . The formula basically says this: for every job requisition that has more than one candidate or more than one job requisition number (whether different or not), i'm asking to return a 1 if it's a minority race. If there are no minorities return a zero and if there is only 1 job req return a zero. Now for every job requistion number that has a 1 in this field i would like to add a total (summing all of the "1"s). If i put =Sum(IIf(Count([Job Req No])>1,IIf((Sum(IIf([Race]<>"White",1,0)))>0,1,0),0)) it gives me an error message "Cannot have aggregate function in expression". I'm not sure how else to go about summing these....HELP PLEASE!!
Thank you in advance