memo fields in access queries (Access 2000)

Topic

New Reply

I have a union query in which one field has a memo data type. In the output of the union query, the content of the memo field is truncated to 255 characters. Is there a way to have the union query output the entire contents of the memo field?

Reply | Quote

Replies

The memo field, called [Description] is in the SELECT, the UNION SELECT, and the last UNION SELECT. The file is attached. The end result pulls records FROM three different queries based on the publication type. (ie. Category1, Category2, BestSeller)

Reply | Quote

Did you ever resolve this problem? I’m experiencing the same thing.

Reply | Quote

I am afraid that this got pushed to a back burner without resolution. My teammates decided to remove the field from the publications catalog and use a smaller [Document Summary] field of data type text instead. A cheap workaround, I’ll admit, but it worked.

aap2

Reply | Quote