Expression of "40 or less" "Greater than 40"

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I need expressions in my report to show a number of "40 or less", "40 to 65"
and '65 or more" this is in reference to hours worked by employee. My
field in the report is [TotalHours] I assume I would need three fields with
three different expressions, Thanks, Randy
 
So, you have a single field coming in to the report and you want those text
values displayed in a single text field on the report?

Make a TextBox and mke the "Control Source":
=IIf([TotalHours]<=40,"40 or less",IIf([TotalHours]<65,"40 to 65","65 or
more"))
 
You misunderstand what I need. I need a column on my report to show actual
hours worked. One column will show hactual hours of 40 or less. Example:
40.0, 39.5, 38.7. The next column will show actual hours of 40.1 to 65
Example: 41.5, 55.8, 64.6. The last coluumn will show actual hours from
65.1 or higher. Example: 65.3, 71.1, 69.5 etc. Can this be done? Thanks.
 
Back
Top