L
lynetteB
I currently have a table in Access 2003 which contains case notes - each
record contains an ID# for the case, date and time fields, etc, and the
actual notes. The notes field is a memo field (currently I have no primary
key assigned to each individual note). I need to export this note data to a
table that will accept only text of 255 characters or less. The new table
will allow for an ID#,lineNo., and textfield.
Is there a way that I can create a query that would take each record from my
current table assign an ID#, then break up the memo field (case notes) into
255 characters sections assigning a line # to each section?
So then the text files can be concatinated(spelling?) in the line # order
when printed.
I hope someone out ther can help me!
P.S. I have very little programming experience, so I have limited
understanding of certain terms.
record contains an ID# for the case, date and time fields, etc, and the
actual notes. The notes field is a memo field (currently I have no primary
key assigned to each individual note). I need to export this note data to a
table that will accept only text of 255 characters or less. The new table
will allow for an ID#,lineNo., and textfield.
Is there a way that I can create a query that would take each record from my
current table assign an ID#, then break up the memo field (case notes) into
255 characters sections assigning a line # to each section?
So then the text files can be concatinated(spelling?) in the line # order
when printed.
I hope someone out ther can help me!
P.S. I have very little programming experience, so I have limited
understanding of certain terms.