[AccessD] Fwd: Memo fields

Rory Archibald responded on Access-L. He said...

My guess: http://allenbrowne.com/bug-18.html

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
Sent: Friday, March 21, 2014 7:58 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Fwd: Memo fields

I asked this twice on Access L but as no one is answering me thought I would cross post here.
Can someone tell me why my memo fields (mail addr, phys addr, notes) are showing garbage in the query output but fine in the table?
>
> SELECT
>
> A.[Company Name],
> A.[Company Mail Address],
> A.[Company Physical Address],
> A.[Company Account Email],
> A.[Company Phones],
> A.[Company Website], A.Notes
>
> FROM
>     [001 Company]  INNER JOIN [001 Company Reminders] as A
>
> ON
>
>       [001 Company].[Company Name] = A.[Company Name]
>
> GROUP BY
>
>        A.[Company Name], A.[Company Mail Address], A.[Company Physical
Address], A.[Company Account Email], A.[Company Phones], A.[Company Website], A.Notes;
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com