Form and Report function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I created if function for one of my fields in database which is ‘test
result’ field. That is a simple function as:

=IIf(([pH] >= 6.45 And [pH] <= 6.74) And
([Concentration] >= 25 And [Concentration] <= 50),
"pass",
"fail")

Now, the problem is that because of this function on my ‘test result’ field,
I can’t get any output for my field in the report part of database. Why is
that?

Thanks in advance,
-Shahrzad
 
Hi,
I created if function for one of my fields in database which is ¡test
result¢ field. That is a simple function as:

=IIf(([pH] >= 6.45 And [pH] <= 6.74) And
([Concentration] >= 25 And [Concentration] <= 50),
"pass",
"fail")

Now, the problem is that because of this function on my ¡test result¢ field,
I can¢t get any output for my field in the report part of database. Why is
that?

Thanks in advance,
-Shahrzad
Click to expand...

This control in the form is a calculated control, and therefore is not
bound to a table, and therefore it is not included in the report's
record source.
If [PH] and [Concentration] are included in the report record source,
simply repeat the calculation in the report.
 
Back
Top