= or >

  • Thread starter Thread starter JohnLute
  • Start date Start date
J

JohnLute

ULW: IIf([ULWinConv]>40,[ULWinConv],IIf([ULWinConv]<40,[PTW]))

More specifically, this needs to return:
If [ULWinConv is equal to OR greater than 40,[ULWinConv]

If [ULWinConv] is equal to OR less than 40,[PTW]

How do I work in the "equal to"?

Thanks in advance!
 
if( a>= b, c, d)


where c is the result to get it a >=b, and d is the result otherwise
(here, if a < b). So:


iif( ulwinconv >= 40, ulwinconv, ptw )



Vanderghast, Access MVP
 
Perfect! Thanks, Michael - that makes sense and works a charm!

--
www.Marzetti.com


Michel Walsh said:
if( a>= b, c, d)


where c is the result to get it a >=b, and d is the result otherwise
(here, if a < b). So:


iif( ulwinconv >= 40, ulwinconv, ptw )



Vanderghast, Access MVP


JohnLute said:
ULW: IIf([ULWinConv]>40,[ULWinConv],IIf([ULWinConv]<40,[PTW]))

More specifically, this needs to return:
If [ULWinConv is equal to OR greater than 40,[ULWinConv]

If [ULWinConv] is equal to OR less than 40,[PTW]

How do I work in the "equal to"?

Thanks in advance!
Click to expand...
Click to expand...
 
Back
Top