Explanation of what query does

[tblues87]

Hi
can someone please explain me what this code means:

File As: IIf(IsNull([Last Name]);IIf(IsNull([First Name]);[Company];[First Name]);IIf(IsNull([First Name]);[Last Name];[Last Name] & ", " & [First Name]))

This query is record source for frmContactsDetails

Thanks

 

[dpw204]

Hi
can someone please explain me what this code means:

File As: IIf(IsNull([Last Name]);IIf(IsNull([First Name]);[Company];[First Name]);IIf(IsNull([First Name]);[Last Name];[Last Name] & ", " & [First Name]))

This query is record source for frmContactsDetails

Thanks

Looks like illogical code to me.

Breaking it down:

IIf(IsNull([Last Name]); ' If Last name field is empty
IIf(IsNull([First Name]);[Company];[First Name]); 'AND in addition to last name being empty
' if First Name is empty, show Company otherwise show first name (doesn't seem to make sense tho')

IIf(IsNull([First Name]);[Last Name];[Last Name] & ", " & [First Name]))
' AND if First name is empty, show last name (which we know should be blank from the first clause) otherwise last name
and a comma space and first name. (which should also be empty) so this should print a comma.

A quick prototype (add the below code to a button might be one way to test)
'======
Dim l, f, c As String
c = "company"
'f = "firstName"
l = "LastName"
MsgBox IIf(IsNull(l), IIf(IsNull(f), c, f), IIf(IsNull(f), l, l & ", " & f))