IIF statements in a report

The correct syntax is:

=IIf(Not IsNull([Staff1]),[Staff1],IIf(Not IsNull([Staff2]),[Staff2], IIf(Not IsNull([Staff3]), Null)

And I would just like to point out that your table structure is not properly normalized (as you shouldn't have repeating fields like that). You should have them stored as RECORDS in another table, and not as columns.

I realize that, however, I didn't create the database so I have no control over how it's designed.

That is giving me an error message.

myblueshadow said:

That is giving me an error message.

Click to expand...

Well, the last time I checked I couldn't see what you see, nor could I read minds, so you'll have to share the text of the error message in order for me to have any clue as to what is happening.

Being rude is supremely helpful!!! Thank you!

It says #Error

Why is it that when someone posts for help on a forum, the replies are all about how much their database sucks and pointing out how much they don't know? Clearly, I posted for help because I needed help. I didn't post so that I could be condescended to!!!

myblueshadow said:

Being rude is supremely helpful!!! Thank you!

Click to expand...

How is that being rude?

It says #Error

Click to expand...

That is what it says in the control? Then it might not like the NULL at the end so change it to "" instead.

Why is it that when someone posts for help on a forum, the replies are all about how much their database sucks and pointing out how much they don't know?

Click to expand...

It isn't that, but we don't just give out blind answers just because we are here doing this to help people LEARN how to do it the right way and not to provide band-aid solutions which will only break and get worse over time.

Clearly, I posted for help because I needed help. I didn't post so that I could be condescended to!!!

Click to expand...

If you felt that you were being treated that way then I'm sorry but the situation is this - you need to understand that on a forum we do not see what you see. So this was being pointed out to you. And if what I wrote stung then you may need to think about getting a thicker skin because it wasn't harsh in the least. It only stated what needed to be stated. If you went to a doctor and said, "doc, I have this ache, what is it?" I think he would be asking you for more information as he can't diagnose without information. Now I tried to put a humorous spin on instead of just saying "NEED MORE INFO" which is what I could have done. But would you have actually learned from that or would you learn more with a statement that we can't see what you see.

So, sorry your feathers got ruffled and, if you wish, I will let someone else respond to your posts from now on. I don't have to answer your posts if you would rather me not.