Bob,
That should be ok.
Personally, I generally prefer the approach suggested by Tom. Also, I
don't think your IIf() applied to the OwnerLastName will actually achieve
anything useful. For neatness, I would do it like this...
OwnerName: [OwnerTitle]+" " & [OwnerFirstName]+" " & [OwnerLastName]
The only proviso I can think of, is that if there is a possibility that
there will be a FirstName but no LastName then the concatenated field will
end up with a trailing space, which you may want to use the Trim()
function to remove.
--
Steve Schapel, Microsoft Access MVP
Thanks everybody made a new field:
OwnerName: IIf(IsNull(tblOwnerInfo.OwnerTitle),'',tblOwnerInfo.OwnerTitle
& ' ') &
IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName &
' ') &
IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName)