Substituting result value in a report?

  • Thread starter Thread starter Robkb
  • Start date Start date
R

Robkb

We have an access database, basically it reports on employees working hours,
one of the fields is overtime, if the employee has worked more than a
certain amount of time it will change the value in this field to a 1 instead
of a 0.

We would like it to display either YES or NO in the report, anyone any tips?

Rob
 
Or use the format property to force the two values.

Set the report control's format to
"YES";;"NO"

Positive values will be displayed as "YES", ZERO will be displayed as "NO"

[MVP] S.Clark said:
=IIF([fieldname]=1, "YES", "NO")

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Robkb said:
We have an access database, basically it reports on employees working hours,
one of the fields is overtime, if the employee has worked more than a
certain amount of time it will change the value in this field to a 1 instead
of a 0.

We would like it to display either YES or NO in the report, anyone any tips?

Rob
Click to expand...
Click to expand...
 
Thanks guys, neither one made any difference, the IIF statement created a
circular error, and the Format made no difference to the output on the
report, by the way using Access 2000


John Spencer (MVP) said:
Or use the format property to force the two values.

Set the report control's format to
"YES";;"NO"

Positive values will be displayed as "YES", ZERO will be displayed as "NO"

[MVP] S.Clark said:
=IIF([fieldname]=1, "YES", "NO")

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Robkb said:
We have an access database, basically it reports on employees working hours,
one of the fields is overtime, if the employee has worked more than a
certain amount of time it will change the value in this field to a 1 instead
of a 0.

We would like it to display either YES or NO in the report, anyone any tips?

Rob
Click to expand...
Click to expand...
Click to expand...
 
Fixed it, thanks guys... the circular error was because it was called
overtime, and calling the data from overtime field, changed the name to
overtime_results and it works a treat

Many thanks

Rob


Robkb said:
Thanks guys, neither one made any difference, the IIF statement created a
circular error, and the Format made no difference to the output on the
report, by the way using Access 2000


John Spencer (MVP) said:
Or use the format property to force the two values.

Set the report control's format to
"YES";;"NO"

Positive values will be displayed as "YES", ZERO will be displayed as
"NO"

[MVP] S.Clark said:
=IIF([fieldname]=1, "YES", "NO")

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

We have an access database, basically it reports on employees working
hours,
one of the fields is overtime, if the employee has worked more than a
certain amount of time it will change the value in this field to a 1
instead
of a 0.

We would like it to display either YES or NO in the report, anyone any
tips?

Rob
Click to expand...
Click to expand...
Click to expand...
 
Back
Top