[AccessD] Nz Joining fields

Virginia,

If [Requestor Name] is the name of the first field and [Customer Name]
is the name of the second field, then try:

[Requestor Name] =
IIf(IsNull(dbo_Requestors.LName])=True,[dbo_customers].[firstname] & " "
& [dbo_customers].[lastname],[dbo_Requestors.FName &" "&
dbo_Requestors.LName])

[Customer Name] =
IIf(IsNull(dbo_Requestors.LName])=True,"",[dbo_customers].[firstname] &
" " & [dbo_customers].[lastname])

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] 
Sent: Monday 2003 Jul 28 10:25
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Nz Joining fields

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]