[AccessD] Nz Joining fields

Hollis,Virginia HollisVJ at pgdp.usec.com
Mon Jul 28 10:24:47 CDT 2003


Awhile back someone sent out how to join 2 fields with an Enter in between
the fields and if one field was Null, it would not show the Enter. I
remember it used the Nz.

I need to concatenate Requestor & Customer. If there isn't a requestor name
it will show the customer only, but on the first line.

Requestor Name
Customer Name

This doesn't work:
CusReq: [dbo_customers].[firstname] & " " & [dbo_customers].[lastname] &
Left(Chr(13) & Chr(10),Len(Nz([dbo_customers].[firstname] & " " &
[dbo_customers].[lastname]))*Len(Nz([dbo_Requestors.FName &" "&
dbo_Requestors.LName]))) & [dbo_Requestors.FName &" "& dbo_Requestors.LName]


More information about the AccessD mailing list