[AccessD] Memo field is truncated

Apparently, removing all criteria did the trick. I told him to just move the 
criteria fields to the resulting table and query there, which doesn't seem 
like it should be necessary, but seems to be working.

Susan H.


> Using the ALL keyword should take care of it:  SELECT ALL FROM ... Etc.
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Tuesday, February 10, 2009 12: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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com