Recent content by TIO OLAN
-
T
If Statement with multiple condition
Hi! I am new to Access formula building and could someone help me to convert this Excel formula (IF statement) to be apply on the Access (design view) query? Excel formula: IF(AND(A2="",B2=""),C2,IF(A2<>"",A2,IF(A2="",B2,IF(B2="",C2,C2)))) I don't know SQL so it is possible to achieve this in... -
T
Date evaluation with Null value using IIF Function
The remarks stated under Employee Status should be my final result in database and I did not get that status because of having null values in some dates like showing in the sample table. Just I dont find best formula to show that Employee status in my database sir. Thank you very much for the help -
T
Date evaluation with Null value using IIF Function
Yes ☺️ Thank you for your reply -
T
Date evaluation with Null value using IIF Function
Hello! Im just want to ask help on my queries with having 5 types of Dates and some of them is having a null value. What would be the best formula or calculation to add the following initial expression including dates with null values: IIf([DATE]>Employee Hire+60,"Production","Nesting")...