IIF doesnt work? Variant-Error?

Slashmaster

Hello again,

in my Memo i want to check, if more then 1 Record is counting.

[COUNT(MasterData2)]

works (for example Result is 26)

if i try this

[IIF(26=26,"(en)","(n)")]

works it too even if i write 26=25 -> Result is "(n)"

But i cant combinate both formulas

[IIF([COUNT(MasterData2)]=26,"(en)","(n)")]

-> Result ERROR

Why and what could i try? Thx a lot!

gordk

first i suggest you read the usermanual on aggregate functions
they are for use in summary type bands footers group footers and page footers column footers and
summary bands.

2nd your syntax is incorrect
in any given expression you are only allowed one set of [ ] braces
[IIF([COUNT(MasterData2)]=26,"(en)","(n)")] wrong.

[IIF(COUNT(MasterData2) = 26,"(en)","(n)")] correct.

BTW these are expressions not code

Slashmaster

Hello gordk,

well, my english issn't good as it should be.. so i red the manuels but misunderstood that the whole expressions must be in [ ]. I thought each "variable" or expression embed in [ ]. [img]style_emoticons/<#EMO_DIR#>/wacko.gif" style="vertical-align:middle" emoid=":wacko:" border="0" alt="wacko.gif" /> Thank u very much![/img]