Field Type

Question posted by: zazu (Guest) on January 1st, 2008 08:35 AM

I use a make table query. A field in the output table is a combination
of three fields and the syntax is:

NewField: [Main]![Field1]&[Main]![Field2]&[Main]![Field3]

Fields 1 through 3 are memo fields, yet the field type for NewField in
the new table is automatically formatted as text. This of course
limits us to 255 chars with the result that some info is being cut
out.

How do I force the query to make the new field a memo field and accept
all the data

Regards to all

Quote | Subscribe