[AccessD] FW: Fwd: Memo fields

Nothing has come to my in-box on Access-L since I wrote asking on Mar 19,.
Thanks for letting me know, I looked into it and apparently some setting for
DIGEST.

I have amended it but it is too late now to see what might have come my way,
I always delete the digest.


> QUERY ACCESS-L
Subscription options for Bill Benson <bensonforums at GMAIL.COM>, list
ACCESS-L:

DIGEST         You receive list digests, rather than individual postings
FULLHDR        Full (normal) mail headers
NOREPRO        You do not receive a copy of your own postings
ACK            Short e-mail acknowledgement of successfully processed
               postings
NOFILE         You do not receive a copy of NJE files sent to the list

Subscription date: 26 Feb 2014

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Friday, March 21, 2014 10:30 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com