Totals query and Memo field

[Jim]

I want to query a table and only display the record with the latest date.
When I add the Totals row to the query grid, the memo fields cut off at 255
characters. Is there any way around this? The fields display everything in
a regular query but I only want the latest date.

Thanks,
Jim

 

[Duane Hookom]

Post your totals query SQL so someone has the best opportunity to help.

 

[Jim]

I found the answer in this newsgroup, just didn't look quite long enough
before posting.

The answer is on Allen Browne's site below.

More info in:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

Thanks!

 

[Jim]

New issue:
I'm able to run this query in Datasheet view and see all of the data,
however, when I run it as an Append query where the receiving table also has
memo fields, the fields are being truncated. I don't see Append or Insert
addressed on Allen's site and hoping to get a solution here. Thank you!

INSERT INTO [JV-KC] ( [qryDate], Project, Staffing, Training, CRE, Assets,
Status, Issues, [Complete Date] )
SELECT Max([KC].qryDate), "KC" AS Project, Last([KC].Staffing),
Last([KC].Training), Last([KC].CRE), Last([KC].Assets), Last([KC].Status),
Last([KC].Issues), [KC].[Complete Date]
FROM [KC]
GROUP BY "KC", [KC].[Complete Date]
HAVING (((Max([KC].qryDate)) Is Not Null));