[AccessD] Fwd: Memo fields

I will understand this better when I get the change into Access, I am not
near a computer.

Seems like this would not work in another platform where FIRST is not
available.

I also might try the indexing suggestion which Allan Browne mentioned.

Thank you Charlotte and Paul. So nice to be be around you all here.
On Mar 21, 2014 9:51 AM, "Charlotte Foust" <charlotte.foust at gmail.com>
wrote:

> Bill,
>
> First is also a grouping option in SQL.  Rather than grouping by the memo
> field, you're selecting the first memo field that comes up as a result of
> groupings ahead of it.  Otherwise, you get into the truncation that messes
> up queries with memo fields.
>
> Charlotte
>
>
> On Fri, Mar 21, 2014 at 5:53 AM, 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>