[AccessD] Fwd: Memo fields

Bill,

Try going to your query in design view and changing the total row for your
memo fields from GROUP BY to FIRST, access has a bit of a problem grouping
by memo fields.

Paul


On 21 March 2014 11:58, Bill Benson <bensonforums at gmail.com> wrote:

> 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
>



-- 
Paul Hartland
paul.hartland at googlemail.com