Text Field

[Denver]

Hi,

I have a Text Field [Done] in my report.
I also have a Text field [Text414], I want that [Text414] will
sum[Done] field for those <>"NA" is it possible?

What woul be my control source for [Text414] field? I am using access 2003.

thanks for any help, I appreciate.

 

[Stefan Hoffmann]

hi Denver,

I have a Text Field [Done] in my report.
I also have a Text field [Text414], I want that [Text414] will
sum[Done] field for those <>"NA" is it possible?

What woul be my control source for [Text414] field? I am using access 2003.

You need a TextBox in the report footer with

=Sum(Iif(Me![Done]<>"NA",1,0))



mfG
--> stefan <--

 

[Denver]

Hi Stefan Hoffman,

=Sum(Iif(Me![Done]<>"NA",1,0))
I tried doing the formula to my records source but when save it
it gives me like this
=Sum(Iif(Me!Done<>"NA",1,0))
and when i click print preview to run the report it pops and Parameter Value.

what else do i miss here?

thanks

hi Denver,

I have a Text Field [Done] in my report.
I also have a Text field [Text414], I want that [Text414] will
sum[Done] field for those <>"NA" is it possible?

What woul be my control source for [Text414] field? I am using access 2003.

You need a TextBox in the report footer with

=Sum(Iif(Me![Done]<>"NA",1,0))



mfG
--> stefan <--

 

[Stefan Hoffmann]

hi,

=Sum(Iif(Me![Done]<>"NA",1,0))
I tried doing the formula to my records source but when save it
it gives me like this
=Sum(Iif(Me!Done<>"NA",1,0))
and when i click print preview to run the report it pops and Parameter Value.

The parameter input box is normally caused by typos in the record source.

what else do i miss here?

Me![Done] references a field name. Is it written properly?



mfG
--> stefan <--

 

[Denver]

Hi,

The parameter input box is normally caused by typos in the record source.

What do you by this? I don't have a paramater value in my query in which
this report is bound of.

=IIf([Status 2]="SLSA",(Sum(Val([Done]))))

In fact I am working on it like this formula it works but it includes the
value of NA..

hi,

=Sum(Iif(Me![Done]<>"NA",1,0))
I tried doing the formula to my records source but when save it
it gives me like this
=Sum(Iif(Me!Done<>"NA",1,0))
and when i click print preview to run the report it pops and Parameter Value.

The parameter input box is normally caused by typos in the record source.

what else do i miss here?

Me![Done] references a field name. Is it written properly?



mfG
--> stefan <--

 

[John Spencer]

Does the field DONE have a number that you are trying to sum or does
that field have various strings N/A, Yes, No, etc.?

You can set the control's source to
=Count(IIF([Done]="N/A",Null,1))

Or if the value is a number string that you want to total
=Sum(IIF(IsNumeric([Done]),Val([Done]),Null))

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================