Problem writing formula in Access

[jy]

Hi everyone,

I am having problem to write a formula in the Access query. Hope someone is
able to help me! ;-D

I have two fields: [Grade] and [Size]. [Grade] consists of A, B, C, D, and E
and [Size] can be any number, eg. 10, 20, 30....

I would like to write a formula to obey the following limits:
If [Grade] = E and [Size]<20, then [Limit] = [Size], else [Limit]=20
If [Grade] other than E, and [Size]<40, then [Limit]=[Size], else [Limit]=40.

Any ideas? Really appreciate the help! ;-)

 

[Graham R Seach]

[Limit] = IIf([Grade] = "E", IIf([Size] < 20, [Size], 20), IIf([Size] < 40,
[Size], 40))

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html