Search results

Thanks for reply I found the error. The correct expresion is =Sum(Iif([Id_Tip]=6;[Supr];0)) But I encountered another problem The results are corect in the detail section of "summaries only" report but the totals over group are incorect in the group footer or group header even I use the same...

I Try to put in a control source from a report the expresion =Sum(Iif([Id_Tip]=6,[Supr],0)) but doesn't work I receive the message The expression you entered contain a invalid syntax Id_tip and Supr are numeric field in the record source of the report (query) Any ideea? Seems to be a simple...