Comparing & replacing values in a form field

[LVROM]

First let me apologize because my english.

I've created an access data base for HHRR control. In a form a have some calculated value fields. For a specific purpose one of the fields has to compare the result of the calculation with an specific value. If the result is higuer than the specified value then the result (just for this calculation) has to be equal to the value.
If I would be programing in Basic it should be something like:

a=b+(b/6)
if a>2759,6 then a=2759,6

My level in Access is very low, so please try to be very clear in your posts


Thanks to everyone for your support

Luis

 

[cogent1]

Luis

In the field where you want your result, put the following calculation

=IIf((B+B/6)>2759.6, 2579.6,(B+B/6))

If B is another field on your form, you must type it as throughout the expression.

 

[LVROM]

Thanks

It works fine.
Thank you very much from Spain
Luis