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.
 
Back
Top