Uppdate query expression problem

[CarlyS]

I have the following expression:

IIf(IsNull(DefinitionField),Null,LabelField)

The goal is to clear a label out of the LabelField if a definition is cleared from DefinitionField. Nothing is happening, however. What am I doing wrong?

Thanks in advance,
Carly

 

[jfgambit]

Try...

IIf(IsNull([DefinitionField]),Null,[LabelField])

 

[CarlyS]

Still nothing...

Thanks for the reply, but that didn't seem to matter. Any other ideas?

 

[jfgambit]

Can you post the SQL of the update query?

 

[CarlyS]

It's a little more complex than my explanation, so maybe it's not just my expression that is the problem. I tried a couple more things and still nothing. What do you think? Here it is:

UPDATE DatasheetTemplateTable INNER JOIN ObjectiveSummarizedTable ON (DatasheetTemplateTable.Ax1Defined = ObjectiveSummarizedTable.ObjectiveSummarized) AND (DatasheetTemplateTable.StudentFullName = ObjectiveSummarizedTable.StudentFullName) SET DatasheetTemplateTable.Ax1Label = IIf(IsNull(DatasheetTemplateTable!Ax1Defined) Or IsEmpty(DatasheetTemplateTable!Ax1Defined),Null,ObjectiveSummarizedTable!ObjectiveNumber)
WHERE (((DatasheetTemplateTable.StudentFullName)=[ObjectiveSummarizedTable]![StudentFullName]));

 

[CarlyS]

Well, I got it working by splitting it into two separate update queries. I don't know if that's the best idea, but at least it's working. Thank you so much for your time and help!