If Condition

[Saeed2007]

Hello All

I want to change this expression from Excel to Access

=IF(J6>500;"6";IF(J6>=200;"5";IF(J6>=100;"4";IF(J6>=50;"3";IF(J6>=10;"2";IF(J6>0;"1"))))))

Thank you.

[MMcCarthy]

Hello All

I want to change this expression from Excel to Access

=IF(J6>500;"6";IF(J6>=200;"5";IF(J6>=100;"4";IF(J6 >=50;"3";IF(J6>=10;"2";IF(J6>0;"1"))))))

Thank you.

That would depend on the field name corresponding to J6. However, the conditional if statement in Access is ...

IIf(Condition, Value if True, Value if False)

So replace J6 with the field name
IF with IIf and ; with ,

This should get you near to what you require.

[NeoPa]

You may find that you don't need to replace the ";" with ",".
I'm not sure why some members seem to need ";" while the typical USA / Britain character is ",". Maybe it's in the regional settings somewhere. You will need to use the character that works for you.
Otherwise MMcCarthy's answer is as much as you can get for that question (and is right of course).