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;