Search results

I have this argument in one of my reports (IIf([ECV2 date]=1,1,0)) in which I want to add the values i assigned to the variable. ECV2 contains a medium date value, is this possible? I wanted to count the number of fields i dont have a date on it.

I have a calculated text box which i named [Files sum] in my reports detail section. It has a control source of {=IIf([ECV2 date]=1,1,0)+IIf([Pass2 date]=1,1,0)+IIf([TWC2 date]=1,1,0)+IIf([EVF2 Date]=1,1,0)+IIf([Medical2 date]=1,1,0)+IIf([Pic2 date]=1,1,0)+IIf([Police2 date]=1,1,0)+IIf([TT2...

I wanted to use IIf function Iif(IsNull([EVF Date]),1,[EVF date]) I also tried using Iif([EVF Date]=" ",1,[EVF Date]) but I get =Error on both expressions when Im running the report. All I want was to put the value 1 when my field is blank (EVF Date is in medium date format) so that i can count...

How can i solved this error? is there a limit in the number of fields that a report contain? when I tried to remove some of the fields, the report comes out without any error. but I need to reflect all these fields in my report. Please help me on this.