Nulls do not propagate (something + null always equals null). When you use
the "+" operator in concatenation, if any null (no middle initial) is
encountered the entire result will be null.
If you used the & operator to concatenate the string Customer Name:
[C_FirstName] & " " & [C_MiddleI] & " " &[C_LastName]
If the Middle initial were null then an extra space would still be added
between the first and last name which would be undesirable.
By mixing the & and + operators (and wrapping the + strings in parenthesis)
we can eliminate the extra spaces.
Try Customer Name: ([C_FirstName]+" ") & ([C_MiddleI]+" ") & [C_LastName]
If either the first name or middle initial are null then the & operator
concatenates nothing to the string but those fields that have a value are
concatenated.
Len
"ernestb08" <er*******@yahoo.comwrote in message
news:11**********************@m3g2000hsh.googlegro ups.com...
>I have a Customers Table with the following field names.
C_FirstName
C_LastName
C_MiddleI
.
.
.
.
.
When I run the query to give me all of the Customers I get all the
information I want.
Now I'm trying to use the zoom function in the QBE window by doing the
following.
Customer Name: [C_FirstName]+" "+[C_MiddleI]+" "+[C_LastName]
By doing this I only the the results of those records that contain a
Middle Initial.
How can I go about to get the results of all the records even those
without a middle Initial?
Any help will be appreciated.
Ernie