Memo fields in queries

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

Hi

I have the same problem - several memo fields, but
truncating at 255 characters - but I cannot see the reply
from Peter Fletcher, only his comment to Steve 'did you
read my response to the original post!'

Assistance will be much appreciated

Sarah
 
Only the first 255 characters are returned if Access is forced to compare
the records based on the memo field. This happens if you use a DISTINCT or
DISTINCTROW predicate, or if you GROUP BY the memo field.

In a Totals query, you can work around this by choosing First in the Total
row under the memo field instead of Group By. Access is then free to grab
the first match it finds, and return the entire memo.
 
This doesn't work for the query I'm working on, here's the SQL:
SELECT Count(Placement.ID) AS CountOfID,
First(Placement.How_my_education_reflects_mission) AS
FirstOfHow_my_education_reflects_mission
FROM Placement;

So all I get is ID (62) and the Memo field is empty.
 

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
disctinct query memo field 3
Memo Field is truncated 5
Query field size quandry 2
memo field in the select query 2
Query Truncating Memo Field 9
Does a Select query copy memo fields correctly? 1
Totals query and Memo field 3

Back
Top