Can't combine memo & Text fields in a query.

D

David

When adding anything in a query next to a field with Data
type = Memo, like this
Combined: [Inventory] ![Product] & [Inventory]![price]
Or
Combined: [Inventory] ![Product] & "instock"
The query will not display more than 256 characters.
(The field [Products] is a Memo type, and the properties
is set to Unicode Compression = Yes)

How do fix this problem?

Thanks
 

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

Can't combine memo & Text fields in a query. 0
combining queries into 1 8
3 queries into 1 8
AT WITS END ON QUERY TOTAL 34
Make Table Query Truncating Memo Field at 255 Characters 1
Query field size quandry 2
Force data type from Text to Memo in a simple Make Table Query 1
Memo fields in a query 10

Top