SELECT IIf(IsNull([LastName]),IIf(IsNull([FirstName]),[Company],[FirstName]),IIf(IsNull([FirstName]),[LastName],[LastName] & ", " & [FirstName])) AS [File As], IIf(IsNull([LastName]),IIf(IsNull([FirstName]),[Company],[FirstName]),IIf(IsNull([FirstName]),[LastName],[FirstName] & " " & [LastName])) AS [Customer Name], Customers.*
FROM Customers
ORDER BY IIf(IsNull([LastName]),IIf(IsNull([FirstName]),[Company],[FirstName]),IIf(IsNull([FirstName]),[LastName],[LastName] & ", " & [FirstName])), IIf(IsNull([LastName]),IIf(IsNull([FirstName]),[Company],[FirstName]),IIf(IsNull([FirstName]),[LastName],[FirstName] & " " & [LastName]));
The problem I have is it lists contact as Customer Name and I Need Customer Name to be Company.
In my forms it is pulling:
Customer Name File As ID Company LastName FirstName Dan Smith Smith,Dan 2 ABC Smith Dan JCF JCF 1 JCF
The null statement is used in a macro filter needed in forms in embedded macro.
Thanks for your assistance.