Iif Function? Access 2003, Query Help ?!?

I would like to create a query displaying that IF a person orders e.g £10.00 or over worth of stock they get a 10% off voucher… ELSE, they recieve nothing. The space is left blank. How do I go about this?
How do I use the IIF function to do this? All help is welcome

Both comments and pings are currently closed.

One Response to “Iif Function? Access 2003, Query Help ?!?”

  1. shrikant says:

    =IIF(fields!fieldName.Value = “check”, True, False)
    Do somthing in true part if condition will true,
    Do somthing in false part if condition will false.

Powered by WordPress | Designed by: free css template | Thanks to hostgator coupon and web hosting reviews