Help Please!!

[svgelacio]

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.

 

[HiTechCoach]

Set a text box's control source in the group or report footer (nopt the page footer) to

=SUM(  IIf( IsDate([ECV2 date field name]) ,0 , 1 )) )

If the field is not a valid date, then it will return a 1 that is summed up. This will give you a count of all the detail records in the group that do not have a date. If in the report footer it will be fore the entire report.

Note: This must reference a field in the record source of the report, not the name of a control on the report.

 

[svgelacio]

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

 

[HiTechCoach]

You're welcome!

Glad we could assist.