Missing data in some reports

[Chigger Hill]

I have a report that pulls in the name and address from my database for a
report by individual. For the names I am using a trim statement like
"=Trim([First Name]+" "+[Last Name]). This works well for most of the
reports. For some business (Not All) with only a last name, none of the name
prints. Some of the business names do print. Suggestions.

 

[Allen Browne]

Try:
=Trim([First Name] + " " & [Last Name])

This takes advantage of a slight difference between the 2 concatenation
operators in Access:
"A" + Null => Null
"A" & Null => "A"

 

[John Spencer]

Simplest is to change the + to &
=Trim([First Name] & " "& [Last Name])

Or force null values (looks like blanks) to zero-length string (different
kind of blank) using the NZ function

=Trim(Nz([First Name],"") + " " + Nz([Last Name],""))

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Chigger Hill]

Works perfectly. Thank you so much.
--
Chigger Hill

Simplest is to change the + to &
=Trim([First Name] & " "& [Last Name])

Or force null values (looks like blanks) to zero-length string (different
kind of blank) using the NZ function

=Trim(Nz([First Name],"") + " " + Nz([Last Name],""))

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have a report that pulls in the name and address from my database for a
report by individual. For the names I am using a trim statement like
"=Trim([First Name]+" "+[Last Name]). This works well for most of the
reports. For some business (Not All) with only a last name, none of the
name
prints. Some of the business names do print. Suggestions.

 

[Chigger Hill]

Thank you very much. Very quick response.
--
Chigger Hill

Try:
=Trim([First Name] + " " & [Last Name])

This takes advantage of a slight difference between the 2 concatenation
operators in Access:
"A" + Null => Null
"A" & Null => "A"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a report that pulls in the name and address from my database for a
report by individual. For the names I am using a trim statement like
"=Trim([First Name]+" "+[Last Name]). This works well for most of the
reports. For some business (Not All) with only a last name, none of the
name
prints. Some of the business names do print. Suggestions.