View Full Version : Comparing to fields and choosing greater amount.


Talismanic
06-28-2000, 07:59 AM
I need to compare two fields and have Access return the greater of the two to a unbound field. Is a IIF statement in the control source of the unbound field he way to do this? How do I set criteria in the IIF for this?

Talismanic
06-28-2000, 11:58 AM
I think I figured it out, this seems to work for me:

=IIf([extrate]>[pwrate],[extrate],[pwrate])