string manipulaton

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
 
J

Jeff Boyce

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top