Concatenating two rows

  • Thread starter Thread starter Clyde Thorne
  • Start date Start date
C

Clyde Thorne

I download a database using ODBC. Problem is if the information (data) is
too long, it forms into another row, finishing out that data. (This is
coming from the original database) Using the Query in Access 2002, design
mode, is there a way to concatenate two rows that have the same column
titles? Each row is identified by a primary number and if the row bleeds
over into a second row, the second column displays a number "2" with the
same primary number, showing that the data is broken into two pieces. The
data I want combined is in column 3. Any ideas?
 
Clyde,

In a new column enter in the Field Row =[1st field name]
&" "&[2nd field name]

The statement basically reads, Show the 1st field name and
a space and the 2nd field name. Substitute the field name
to correspond with your query.

Charlie O'Neill
 
ParcelNumber LegalLineNumber LegalDesc1
MI01.953.020.0001 1 UNPLATTED PORTION
OF NW 1/4 OF
MI01.953.020.0001 2 PLAT OF
FLEXI-COIL ADDITION
MI01.953.020.0001 3 ADDITION AND
BOUNDED ON THE WEST

This is a copy of the problem I have. When the LegalDesc1 is too long, it
forms another row with the same ParcelNumber. How do I concatenate the rows
together?
clyde


Charlie said:
Clyde,

In a new column enter in the Field Row =[1st field name]
&" "&[2nd field name]

The statement basically reads, Show the 1st field name and
a space and the 2nd field name. Substitute the field name
to correspond with your query.

Charlie O'Neill
-----Original Message-----
I download a database using ODBC. Problem is if the information (data) is
too long, it forms into another row, finishing out that data. (This is
coming from the original database) Using the Query in Access 2002, design
mode, is there a way to concatenate two rows that have the same column
titles? Each row is identified by a primary number and if the row bleeds
over into a second row, the second column displays a number "2" with the
same primary number, showing that the data is broken into two pieces. The
data I want combined is in column 3. Any ideas?

--
Clyde


.
Click to expand...
Click to expand...
 
Back
Top