Nested IF

[balajigade]

I have a database of employees in & out punching to the office. The fields are Date, EmpCode, Intime, Outtime, Comments. I want generate a query for the field " Comments" as follows :



IF intime = null AND outtime = null, Comments = "Absent"
IF intime = null AND outtime = "", Comments = "Late"
IF intime = "" AND outtime = null, Comments = "Left Early"
IF intime = "" AND outtime - "", Comments = "Present"

I tried various combinations of IIF, OR, AND functions but without any success. The intime & outtime values are in time format, hr:mm

Pl suggest a solution

Thanx

[June7]

Can't test for = Null http://allenbrowne.com/casu-12.html

intime and outtime are text type fields? Why would the fields have empty string? Is empty string set as a DefaultValue for textboxes? I never allow empty string in text fields.

Switch(IsNull(intime) AND IsNull(outtime), "Absent", IsNull(intime) AND outtime="", "Late", intime="" AND IsNull(outtime), "Left Early", intime="" AND outtime="", "Present")

[balajigade]

The intime & outtime fields are in time format, not as text. I might have made a mistake while denoting the string as " ". The data comes as an excel file which is pasted on to the access table on daily basis. The null values appear when there is no time punch during either checking in or checking out or both, when absent.

[June7]

A date/time type field cannot hold an empty string, therefore your conditional code will fail.