Problem querying a memo field

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I have a query to export the content of a memo field to excel. The query
result cut of some part of the text. How do I overcome this problem?

SF
 
Post the SQL of your query.

Memo fields will get truncated if you use DISTINCT or a totals (aggregate)
query.

First, is the query truncating the data or is the export truncating the
data? If you run the query without exporting the data is the memo field
truncated? Or does the truncation appear after you have exported the data.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Hi,

My query is listed below:

SELECT tblOrganization.Org_ID, tblOrganization.Org_Abbreviation,
tblOrganization.Org_MissionStatement
FROM tblOrganization
GROUP BY tblOrganization.Org_ID, tblOrganization.Org_Abbreviation,
tblOrganization.Org_MissionStatement;

In fact I did group the query result, that is why the result is truncated
even I ungroup them. I am end up with creating a new query.
 
If it doesn't matter which mission statement you get for the group, then try

SELECT tblOrganization.Org_ID, tblOrganization.Org_Abbreviation,
First(tblOrganization.Org_MissionStatement) as MissionStatement
FROM tblOrganization
GROUP BY tblOrganization.Org_ID, tblOrganization.Org_Abbreviation

I really don't see the point of using an aggregate query in the above SQL.
I would think that ORG_ID would be unique within the table and therefore all
you would really need would be a standard select query.
SELECT tblOrganization.Org_ID
, tblOrganization.Org_Abbreviation
, tblOrganization.Org_MissionStatement
FROM tblOrganization


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top