Where can I find a list of keywords/functions that are allowed in formula? I'm surprised that it doesn't support 'and' / 'or' like in the ff. example:
ucol.Formula = "if(((([age]) > 25) or (([salary]) < 500)), 100, 0)"
It will also be good to know if other sql functions are supported like the 'isnull'.
Hi,
If you go to the Formula property of any control or object at design-time, it will bring up the formula builder which has a complete list of all functions.
You can also do a search in the online help for the word functions and it will take you to lists of functions by category.
'and' and 'or' are supported as functions.
formula = IF ( OR([a], [b]), 1, 0)
formula = IF ( AND([a], [b]), 1, 0)