Minimum charge

[JohnV]

Don't know if you got your answer but the code should read:
=IIF([Miles]*[ContractRate]<500,"500",[Miles]*
[ContractRate])

Regards,
JohnV

-----Original Message-----
It tells me there is an "invalid syntax" when i try to use
this formula. I tried entering a parenthesis at the end to
enclose the final statement but that didn't work and also
before the comma but after the quoted 500 and that did not
fix it...any ideas? TYIAA

-----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