Recent content by svgelacio

thanks HiTech Coach, it works.. I even figured out how to attack other reports similar to this.:)

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.

ok, i got the idea (both ideas that is) and i wanted to count the occurences of 0, how can i do that? thats the one i wanted to reflect in my report fotter.

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...

Is there any other way like adjusting the number of fields to be accomodated in the options menu or something like that?

okay its working, one more question please. how can i convert now the field so that it will show the actual date field I entered in the form. like (EVF Date) supposedly (medium date) 30-December-2008 but is now showing (39,999).

yeah this is already one of the sub reports i did, its actually 1 of 3 pages of my weekly report, I can no longer take off some of the fields since this is already the summary. I really have to figure out how to present it if the fields are finite.

thanks, so I really have to do it first in a query, im working on it directly on the report (control source). the error is =IIf(IsNull([ECV Date]),1,[ECV Date]) on this part of the expression and the return value for iif(IsNull([ECV Date]) is 30-Dec-1899, does it mean that its not Null after...

Im working on about 350 or more fields in one report. Also, this is on the report footer section im utilizing.

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.