Text Field

  • Thread starter Thread starter Denver
  • Start date Start date
D

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.
 
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.
Click to expand...
You need a TextBox in the report footer with

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



mfG
--> stefan <--
 
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

Stefan Hoffmann said:
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.
Click to expand...
You need a TextBox in the report footer with

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



mfG
--> stefan <--
Click to expand...
 
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.
Click to expand...
The parameter input box is normally caused by typos in the record source.
what else do i miss here?
Click to expand...
Me![Done] references a field name. Is it written properly?



mfG
--> stefan <--
 
Hi,
The parameter input box is normally caused by typos in the record source.
Click to expand...
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..




Stefan Hoffmann said:
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.
Click to expand...
The parameter input box is normally caused by typos in the record source.
what else do i miss here?
Click to expand...
Me![Done] references a field name. Is it written properly?



mfG
--> stefan <--
Click to expand...
 
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
'====================================================
 
Back
Top