[AccessD] Fwd: Memo fields

Bill Benson bensonforums at gmail.com
Fri Mar 21 06:58:00 CDT 2014


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;


More information about the AccessD mailing list