Memo Fields in Query

D

Dan

Hi all !

I wonder if anyone could help. I need to create a Report based on a query
that pulls data from numerous tables in my database, one of the fields I
require in the report happens to be a Memo field. The problem I have is
that when pulling data in a Memo field from a Query I only get the first 255
characters in the result, the rest is not retrieved. Is there any way I can
get round this, I need all the text in the memo field to appear in the
report but the data the report must produce needs to come from a variety of
tables.

Any help would be hugely appreciated ! Kind Regards

Dan
 
D

Dan

Hi

With some help I've now resolved this problem, it was due to a Group By
clause being present in the SQL statement. Many thanks for your assistance

Regards

Dan
 

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
memo field in the select query 2
disctinct query memo field 3
Memo fields in a query 4
Memo fields not displaying in query 4
Query field size quandry 2
Exporting Memo fields into Excel 1
Can rich text format (memo) carry over in a make table query? 1

Top