Dan Waters
dwaters at usinternet.com
Tue Feb 10 15:01:59 CST 2009
Hi Susan, Look for some kind of DISTINCT query or recordset. If a memo field is included, it will be truncated. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Tuesday, February 10, 2009 2:53 PM To: AccessD at databaseadvisors.com Subject: [AccessD] Memo field is truncated I've seen this discussed many times, but I can't remember the solution -- a reader's Make Table query is truncating a Memo field to 255 characters. I've found a few things on the kb, but nothing that seems to be the exact thing I'm looking for -- nothing for Make Table anyway. I've sent links to the few articles that are close. Does anyone remember what this is -- off the top of your head? Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com