View Single Post
  #6  
Old June 3rd, 2010, 08:56 PM posted to microsoft.public.access.reports
KG
external usenet poster
 
Posts: 83
Default Firstname plus Middlename??

Thank you so much! As they say, "a little knowledge is a dangerous thing".
It all is working perfectly.


"John Spencer" wrote:

You should be using the & concatenate operator instead of the + operator.

The plus returns blank if any of the values are null (blank/never entered).

The & operator treats nulls as if they were a zero-length string ("") and so
has no problem if any of the fields are blank - other than you may get some
unwanted spaces.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

KG wrote:
Apologies if this is a silly question. I'm trying to combine Lastname,
Firstname Middlename in a report. I have
=([surname]+", "+[firstname]+" "+[middlename]).
The only time it works is if all three fields contain values. As the
majority of players don't have middle names in the database, most of the
report is blank.
Can anyone tell me what I'm doing wrong?
Thanks so much for your help.
Kind regards...

.