Need help creating a yes/no box in a report

[Southskier]

I have a database that I need to have a yes/no box based on crieteria that is
output in the report that I have created. The employees are getting bonuses
based upon the following: attendance, department productivity(effectiveness),
and QC Occurances. Is there an easy way to create a box that will say YES if
they have 0 absences and QC Occurrances and 85% department productivity, or
NO if they have any absences/QC and under 85% prod?

Thanks,
Rob

 

[Guest]

Hi

You can do this in a query calculated column
Bonus: =IIf([TableName]![Absences]=0 And
[TableName]![Productivity]>85,"Yes","No")

Or on a form (source of a text box)
=IIf([Absences]=0 And [Productivity]>85,"Yes","No")

Just one point how are you getting the result 0 for Absences?

Or you can do this in the report itself (in the detail footer)
=IIf(Count([Absences])=0 And [Productivity]>85,"Yes","No")

etc
etc

 

[fredg]

I have a database that I need to have a yes/no box based on crieteria that is
output in the report that I have created. The employees are getting bonuses
based upon the following: attendance, department productivity(effectiveness),
and QC Occurances. Is there an easy way to create a box that will say YES if
they have 0 absences and QC Occurrances and 85% department productivity, or
NO if they have any absences/QC and under 85% prod?

Thanks,
Rob

Add an unbound check box control to the report.
Code the Detail Format event (if the control is in the detail section)

Me![CheckBoxName] = ([Absences] = 0 and [QC ocurrances] = ? and
[Productivity] >= .85)

Change the field names and actual values as needed.