I've downloaded the Contact Management Database template and was wondering about these two query statements.
The first and second columns are expressions.
The third column in the query is Contacts*. The record source for "Contact Details" form is this query.
The two statements are almost identical with the exception of the expression name. I understand what the expressions do, just not sure on the purpose as it seems redundant to me...
Cheers!
-Kyp
The first and second columns are expressions.
Code:
File As: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))
Contact Name: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))
The two statements are almost identical with the exception of the expression name. I understand what the expressions do, just not sure on the purpose as it seems redundant to me...
Cheers!
-Kyp