concatenate

  • Thread starter Thread starter JH
  • Start date Start date
J

JH

Access 2003
I have a table with three fields. All the rows in column A and C have data
in them, however column B may or may not have data. I need to create a query
to concatenate the fields in column D but maintain the blank data in field
B. For example
A B c d
abcd efgh ijkl abcdefghijkl
abcd ijkl abcd ijkl
Any ideas?
Your help is much appreciated. Thanks
 
Since there is no data if field B there is nothing to maintain. Perhaps you
mean that you want to insert some spaces or underscore characters if field B
is Null

[A] & NZ(," ") & [C]

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