how do I increase a query field size to more than 255 characters?

G

Guest

I have a query based on a table. the table contains a field which holds a
large amount of text data, so I have set its data type to Memo. No problem.
But the query will only display (and export) the first 255 characters of the
large amount of text in each record, and I cannot find any method to increase
this, despite searching high and low in the Help sections etc, but logically
speaking there must be a way of doing it.
I could work without the query I suppose, and pull the info straight of the
Table, but I would prefer not to. Please advise.
 
D

Duane Hookom

It might help if you offered up a view of the SQL of your query. You might
have phrases like "DISTINCT" or "GROUP BY" or other that would limit the
number of characters.
 

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

Make Table Query Truncating Memo Field at 255 Characters 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Query field size quandry 2
Query Returns First 255 Characters of Memo Field 2
disctinct query memo field 3
How can I convert text field to memo field in a query 10
Can a query return a result greater than 255 characters? 2
How to insert data more than 255 into memo field? 1

Top