| | |
|
|
|
Concatenating two rows |
|---|
| message from Clyde Thorne on 20 May 2004 |
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?
|
| Charlie replied to Clyde Thorne on 20 May 2004 |
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
information (data) is
data. (This is
Access 2002, design
the same column
if the row bleeds
number "2" with the
two pieces. The
|
| Clyde Thorne replied to Charlie on 21 May 2004 |
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" <anonymous@discussions.microsoft.com> wrote in message
news:fe2001c43e9f$6977fd50$a501280a@phx.gbl...
|
|
Archived message: Concatenating two rows (MS Access)
