[AccessD] Fwd: Memo fields

Paul Hartland paul.hartland at googlemail.com
Fri Mar 21 08:08:35 CDT 2014


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


More information about the AccessD mailing list