Update unbound box with time

[priac]

I am new and having a problem with something that should be simple. I have a query that returns a time to a form.
=Sum([Expr1])

I want to tell an unbound text box to show 40 if the =Sum([Expr1]) is => than 40.

 

[dhookom]

Probably something like:

=IIf(Sum([Expr1])> 40 , 40, Sum([Expr1]))

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

Should'nt that be:

[blue]=IIf(Sum([Expr1])>[purple][b]=[/b][/purple] 40 , 40, Sum([Expr1]))[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[dhookom]

You could use the = but the results would be exactly the same.

Duane
Hook'D on Access
MS Access MVP