What's wrong with this expression?

[R1RAY]

This in a Text Box control on an access report. I get the "wrong number of arguments" message, but what is the correct number of arguments?

=IIf(([Hours]=4),IIf([MAIL_LOG_TIME])<=#12:00:00 PM#),
([MAIL_LOG_DATE]&" "&DateAdd("h",4,[MAIL_LOG_TIME]),""))

[Rabbit]

Go through the expression and match all the opening parentheses to its closing parentheses

[R1RAY]

Still not working, wrong number of arguemnts:

=IIf(([Hours]=4),IIf([MAIL_LOG_TIME])<=#12:00:00 PM#),([MAIL_LOG_DATE])&" "&DateAdd("h",4,([MAIL_LOG_TIME]))

[Rabbit]

Because you still haven't matched them up correctly. Show me which opening parentheses you think matches up with which closing parentheses.

Break out the innermost blocks and look at those separately before trying to combine them all together.

[ADezii]

Your Syntax is incorrect, Copy-N-Paste the following to the Control Source of your Text Box:

=IIf([Hours]=4,IIf([MAIL_LOG_TIME]<=#12:00:00 PM#,[MAIL_LOG_DATE]+DateAdd("h",4,[MAIL_LOG_TIME]),""),"")

[R1RAY]

Thanks, that worked. I am still having trouble counting out the arguments.

Thanks
-ray

[Rabbit]

The syntax for iif is this:

iif(a, b, c)

For any of those variables, you can embed another function, another iif in your example. But you must maintain the same syntax. So if you want to replace b with this:

iif(x, y, z)

Then you just fully replace b with that. Resulting in this:

iif(a, iif(x, y, z), c)

You can't just drop random variables and move the parentheses around willy nilly.