[AccessD] Fwd: Memo fields

That is so interesting.  Microsoft has a bug in an implementation of
something only Microsoft has (memo fields) and it is fixed by an
aggregation only Microsoft has, and further it is confirmed that the fix is
faster and cures the other inherent limitation of memo fields (<=256)

This isn't horses for courses it is course for horses...

Well thank you for your digging, I should have performed a better search.
Howe er, we talk about so little Access related stuff here I figured no
harm done even if it were a well traversed course or a worn out horse.
On Mar 21, 2014 9:10 AM, "Paul Hartland" <paul.hartland at googlemail.com>
wrote:

> Bill,
>
> Found a microsoft page with the same :
>
>   http://support.microsoft.com/kb/889490
>
> Paul
>
>
> On 21 March 2014 13:05, Paul Hartland <paul.hartland at googlemail.com>
> wrote:
>
> > I couldn't remember why I thought of that so I done a search, and this
> > website rings a bell for me from a while back when I had a similar
> problem,
> > im sure it worked...
> >
> > http://allenbrowne.com/bug-18.html
> >
> > Paul
> >
> >
> > On 21 March 2014 12:53, Bill Benson <bensonforums at gmail.com> wrote:
> >
> >> Isn't first something one puts in the select clause? Not familiar with
> >> syntax in group by field.
> >> On Mar 21, 2014 8:11 AM, "Paul Hartland" <paul.hartland at googlemail.com>
> >> wrote:
> >>
> >> > 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
> >> > --
> >> > 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
> >>
> >
> >
> >
> > --
> > Paul Hartland
> > paul.hartland at googlemail.com
> >
>
>
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>