By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,460 Members | 2,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,460 IT Pros & Developers. It's quick & easy.

Help combine two records

P: n/a
IMT
Hi all

I need some help.

i have a Db with 3 simple fields used for extended descriptions.

fields are

Itemnumber - sequense - comment

Data is like

d34563 - 000 -
d34563 - 001 - part description line 1
d34563 - 002 - part description line 2
and so on

what i need to do is take comment seq 001 and add comment seq 002 to
the end of it with a space inbetween.

creating a new table with part number and a concatinated comment field
iw what i am after.

Please Help.

Jimbo
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ca*********@usa.net (IMT) wrote in message news:<a3**************************@posting.google. com>...
Hi all

I need some help.

i have a Db with 3 simple fields used for extended descriptions.

fields are

Itemnumber - sequense - comment

Data is like

d34563 - 000 -
d34563 - 001 - part description line 1
d34563 - 002 - part description line 2
and so on

what i need to do is take comment seq 001 and add comment seq 002 to
the end of it with a space inbetween.

creating a new table with part number and a concatinated comment field
iw what i am after.

Please Help.

Jimbo

http://www.mvps.org/access/modules/mdl0004.htm
"Although saying so means nothing, others it leaves nothing to be said..."
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.