Data from another field

natural · Jan 20, 2011

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 · Jan 20, 2011

I believe you just had an omission. Try this:

Code:

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

vbaInet · Jan 20, 2011

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 · Jan 20, 2011

vbaInet said:
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.

Data from another field

natural

Registered User.

spudracer

Here and there

vbaInet

AWF VIP

spudracer

Here and there

Similar threads

Users who are viewing this thread