Re: Group by truncating field
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Fri, 7 Mar 2008 00:28:55 +0900
In the Total row under your memo field in query design, use First instead of Group By.
Explanation:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Question Boy" <QuestionBoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95B5EFAE-C6E3-4C24-A9F9-FCB0802D3CC4@xxxxxxxxxxxxxxxx
I have a simple query
SELECT [Tbl Contacts].First, [Tbl Contacts].Last, [Tbl Contacts].Notes
FROM [Tbl Contacts]
GROUP BY [Tbl Contacts].First, [Tbl Contacts].Last, [Tbl Contacts].Notes;
However, it is truncating the content of my memo field Notes. How can I
return the complete field value?
.
- Prev by Date: Re: Avoid append queries too many times a day
- Next by Date: Re: find/replace characters like quotes
- Previous by thread: Re: Need help calculating queries & reports
- Next by thread: RE: Strange result from query, '>' gives same result as '>='
- Index(es):
Relevant Pages
|
