Syntax Error

[Vishal123]

Hello,

I am a very infrequent user of access and am having some issues with an update query.
Can someone please advise a possible solution for this update query...

I am trying to update a table but getting a syntax error in the iif function
:
iif( [tblUserAccess]![Reschedule_Tranche] isNotNull, [tblUserAccess]![User_Tranche] = [tblUserAccess]![Reschedule_Tranche], [tblUserAccess]![User_Tranche] = [tblUserAccess]![Tranche])

I am trying to achieve that if reschedule Tranche (column ) in tblUserAccess is not null then User Tranche (column in the same table) should be same as reschedule Tranche. Otherwise User Tranche should be same as Tranche (another column in the same table).

Thanks in advance for your help..
Cheers

 

[haresh]

you can try with

"Is NotNull" insted of "isNotNull"

 

[vbaInet]

Can someone please advise a possible solution for this update query...

I am trying to update a table but getting a syntax error in the iif function

A possible (and sensible) solution is NOT to save the calculated value. Simply calculate it on-the-fly and display it when necessary.

Nz([Reschedule_Tranche], [Tranche])

But it sounds like your tables are not normalised.