1. IIf(IsNull([LastName]),IIf(IsNull([FirstName]),[Company],[FirstName]),IIf(IsNull([FirstName]),[LastName],[FirstName] & " " & [LastName]))
2 IsNull([InvoiceID])
Thank you very much for your help.!!!
KerryDee
1. IIf(IsNull([LastName]),IIf(IsNull([FirstName]),[Company],[FirstName]),IIf(IsNull([FirstName]),[LastName],[FirstName] & " " & [LastName]))
2 IsNull([InvoiceID])
Thank you very much for your help.!!!
KerryDee
Thank you very much that helped tremendously.