G
Guest
TY So Much!!! 
-----Original Message-----
Try this as the Control Source for the field:
=IIF([Miles]*[ContractRate]<500,"500",([Miles]*
[ContractRate]
this simply says that if the total is less than 500, enter
500; otherwise, enter the actual miles times contract rate
.-----Original Message-----
I am a beginner Access user. I cannot write code so I put
statements in the 'control source' section of the
properties in order to get the results I want.
My problem is that I have a unbound calculated field in my
report to determine '[Miles]*[ContractRate]' however if
that resulting number is less than a certain number (say
500) I would like the 500 to be displayed instead of the
originally calculated number.
Can anyone recommend a statement that would make this
result? TYIA
Chelle
.