Totals query and Memo field

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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));
 
Back
Top