Concatenate large text fields into common memo field

D

Dirtbike

I need to cat record fields. The problem is my record fields are in effect
text notes. The notes come from ODBC and may alreay be truncated to 255
characters..that's OK. I used the CONCATENATE() function written by Duane
Hookom and it seems to work. Eventually, I want a memo field to contain all
the. When I cut-n-paste the datasheet output of the quesry all the data is
there...when I 'make table' it gets truncated @ 255....
Hey, you think I will need to write a report and then use the report as the
source of yet another table?
I really only need a 'one time' deal so if I have to stand on my head and
recite the declaration of Independence or some such rig-a-marole that's OK.
 
D

Dirtbike

Do'H, I got it!! Take this query and append to a table created with a memo
field where the text field was. This works great....sometimes asking for
help is all the motivation I need to find a solution.
 

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

Similar Threads

text box in report is truncating memo field at 255 characters 2
insert memo feild into a memo field truncates at 255 characters - 4
appending more than 255 characters into a Memo field 7
conditional format truncates memo field 1
How to Print a large memo field on multiple pages without losing . 1
Memo Field Truncates my Data in Table?! 6
Memo Field in Table Truncated in query results and in report 1
Memo field is truncating in group heading of an Access 2007 report 3

Top