Report Count Error

[pekuiper]

I want to count the # of fields in a report that have data like you would in a SUM field. In the Control Sourse I have =Count([DISCLeavel1]) but I get an error when I preview it...can any one help me with this.

 

[Brianwarnock]

Is [DISCLeavel1]) the name of the control or the name of the Control Source, it has to be the latter.

brian

 

[pekuiper]

The Control Source if I put =Sum in the place of =Count it works.

 

[Brianwarnock]

Puzzling, but since Sum is finding the data you could try
=Sum(IIF(not IsNull([DISCLeavel1],1,0)

Brian

 

[pekuiper]

Thats odd I had to modify yours to =Sum(IIf(Not IsNull([DISCLeavel1]),1,0)) but it worked. Doesn't make sence to me but this will do. Thanks a million for the help.

 

[Brianwarnock]

Sorry the ( ) s were wrong, but glad you sorted it and it worked, doesn't make sense to me on the face of it .

Brian