Data from another field

[natural]

Hi

Is it possible that if you have field in a query that displays a blank field you can say

iff the field RoomNo is null use the data from the field RoomAssigned
(in the same query)

i typed this in criteria in the field roomNo

iff(isnull[RoomNO]),[bkrmassigned])

and it gives me an error
Undefined function iff in expression..

am i doing this correct.

 

[spudracer]

I believe you just had an omission. Try this:

iif(IsNull([RoomNO]), [bkrmassigned])

 

[vbaInet]

You're almost there but it's missing one more parameter. Here's the structure of the IIF() function:

IIF([Field] = something, True Part, False Part)

You can see you're missing the false part.

Edit: Plus spudracer's comment too about a missing start parens for IsNull()

 

[spudracer]

You're almost there but it's missing one more parameter. Here's the structure of the IIF() function:

IIF([Field] = something, True Part, False Part)

You can see you're missing the false part.

Yep, that's what I was thinking, too, but saw that not all there code was there, so I figured it was something simple. I guess it was, more or less.