Calculated field.

[ssu]

Does anybody know how to
" Add a calculated field named CustomerName as the first column that is either the company or the concatenation of the last name, a comma a space, and the first name. Sort in ascending order by Customer Name ?"



I've came up with CustomerName: IIf([CompanyName] , [LastName] & ", " & [FirstName])
and it doesn't work...help!

[pbaldy]

Homework? I'd use IsNull() to test the company name, and you haven't filled in the False argument of the IIf().

[ssu]

What's the false argument?
Thanks for the reply-

[ssu]

I've come up with CustomerName: IIf(IsNull([Company Name]),[Last Name] & ", " & [First Name])
But the fields that have company name values don't show any field values,,

[pbaldy]

Have you looked in help at the IIf() function? It has 3 parts, you've only used 2.

[ssu]

you mean the <<falsepart>>? but I am not sure what to put there,,

[pbaldy]

You put what you want the function to return if the test is false (company name isn't Null).

[ssu]

I put [LastName] but it still doesn't work....

[pbaldy]

If company name isn't Null don't you want...company name?