IIf Function, please help

[Georgi]

Good morning Ladies and Gentlemen,



I was trying to use the IIf fuction I have already used it on excel database, it does not work!

The function is [=IF(AND(C3="Truck",B3="Damage")=TRUE,"X"," ")].

Please see attached files,

Thank you very much for this great website.

Have a good day,

[alansidman]

In Access the syntax is slightly different.

=IIF(C3 = "Truck" and B3 = "Damage","X"," ")

However, in Access, you probably want the empty field to be NULL instead of " ". These two items are not the same.

Look here for a complete tutorial.

http://www.techonthenet.com/access/f...vanced/iif.php

http://allenbrowne.com/vba-NothingEmpty.html

[Georgi]

Good evening, thank you Sir for the great help, it works 100%, I apologise I cannot access the below link because internet is down now I am using a mobile phone right now, once the connection back I have another critical issue with graphs, however thank you very much and appreciated

[Georgi]

I went through the links, wonderfull,

This problem has been resolved I don't know how to close I am still looking for the sign "*" to click it!

Thank you,