string manipulaton

  • Thread starter Thread starter Mario Krsnic
  • Start date Start date
M

Mario Krsnic

Hello,
a similar problem was discussed above, but I need nevertheless help.
I have in my first table a text field with many recordsets. I have in the
second table
a memo-field. I would like to insert data from the first table in the second
one. All rs which
have the same string on the very beginning (5 same characters) should become
a part of the
same recordset in the new table.

Thanks in advance!
Mario
 
Mario

A general consideration in database design (with relational databases, e.g.
Access), is that you generally neither need nor (truly) want to store
calculated data. Putting something from table1 into table2 sounds like
storing calculated data.

Also, the terminology that you've used to describe your situation can be
interpreted more than one way. In Access terminology, a recordset is a set
of records. Thus, it would be difficult to imagine how you could have "a
text field with many recordsets".

Perhaps if you gave an example of the data you have (just a few records), it
would help clarify what you are trying to do -- you've describe "how" you
are trying to do it.

More info, please...

Jeff Boyce
<Access MVP>
 
Back
Top