Concating 3 records to 1 - Urgent

  • Thread starter Thread starter Rajesh Candamourty
  • Start date Start date
R

Rajesh Candamourty

Dear All,

i have a table with 1 field full of comments like

Table1;

SNo Comments
1 This tester cannot be tested as if fails in the floor.
2 Part number 32499.S has to be replace by 6733.S. Line stopped.
3 Check the routers, urgent.
.. .
.. .
.. .and so on.

i want to have all the comments in one record seperated by an "##"
character;

SNo Comments
1 This tester cannot be tested as if fails in the floor. ## Part
number 32499.S has to be replace by 6733.S. Line stopped. ## Check the
routers, urgent.

How do i do this, i tried some ways but failed. I tried insert, update
statements. didn't work. i am wondering is there an append statement?
I would appreciate any help.

Thanks.
Raj.
 
Do you mean that those comment are three separate records, or that they are
three fields within one record? The meaning of "1 field full of comments" is
not clear. If they are three fields in the same record you can just
concatenate them in an unbound text box on a form or report. The unbound
text box would have as its control source something like:
=Me.txtText1 & " ## " & Me.txtText2 & " ## " & Me.txtText3
There is no need to store the concatenated value. If you are trying to
achieve that look with three separate records it is a whole different
problem.
 
Dear Bruce,

Thabnks for ur input.
table1 has 3 different records. those comments should be saved in another
table and in one line.
i would appreciate if u can give me some ideas.

thanks.
Raj
 
What do you mean when you say that table1 has three different records? A
record is a set of fields related to something. For instance, an Employee
table may contain an employee ID number, last name, first name, and so forth.
The other point is that if you have already saved data there is no reason to
save it again.
What is the purpose of table1?
 
Back
Top