if statement

[Anonymous]

my question is:

how do you write code that uses the field name with an If statement;

e.g. If tree = 'Y', then get the tree name from Tree Name column

IF( Tree = 'Y', Tree Name)

[sunny_talwar]

Looks right to me. Is it not working?

[Chanty4u]

try fro the same

IF( Tree = 'Y', [Tree Name],[Tree Name])

[hartleyr]

If you are calling a column with spaces in the name, then this will have to be surrounded by square brackets;

if(Tree = 'Y', [Tree Name])

If using this statement in a text box, it will have to be proceeded with an equals.

[Anonymous]

I don't get the tree names.

[Anonymous]

it is now working; I surrounded the field name with quotation marks