No but it is accomplishing a count of a field....perhaps that is what is causing the problem.
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Brodeur, Rich Sent: Friday, August 24, 2007 2:23 PM To: [email protected] Subject: RE: [ms_access] Memo Field truncated in query result Hi Ya'll, I have previously fallen into this trap too in the past and found myself scratching as to why. Is by chance your query doing totals....'Group Bys'? That was my problem with memo fields geting truncated to 255 characters. As soon as I changed it to a straight query, I got the entire contents of the field. Rich ________________________________ From: [email protected] <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ] On Behalf Of Dave Moreau Sent: Friday, August 24, 2007 3:13 PM To: [email protected] <mailto:ms_access%40yahoogroups.com> Subject: RE: [ms_access] Memo Field truncated in query result Dawn: Still having a tough time getting that field not to truncate. I tried taking that field out of the original query, made it into its own query with the id field, and then linked the original query to the new id field and Location query. It is still truncating the field though. I am accomplishing a count on a field in that same query....is that what might be causing it to truncate? I am not sorting in the query but I am sorting/grouping by date in the report. What am I still missing here? Dave -----Original Message----- From: [email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> ] On Behalf Of Dawn Crosier Sent: Friday, August 24, 2007 9:53 AM To: [email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> Subject: RE: [ms_access] Memo Field truncated in query result If you are sorting in your Query, then it will truncate to the first 255 characters of your memo field. What most people do to create their report is they create the query and then add the memo field in the record source of the report to get the memo field in there as well. So you would have two queries linked together where the one query does the sorting and the other query has the memo field and id field so you can join them together and use them in your report. Dawn Crosier Microsoft Word MVP "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -----Original Message----- From: [email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> ] On Behalf Of Dave Moreau Sent: Friday, August 24, 2007 7:07 AM To: [email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> Subject: [ms_access] Memo Field truncated in query result Why would a memo field be trunacted in a memo field when running a query/report? The query does not pull all of the text in from the table....all of the information is in the table but the query on the memo field truncates the entry in the report. The report filed is set to Can Grow but I noted the query itself is truncating the memo field - thus the report is not fed all of the data. Thanks! Dave Moreau = = = = = = = = = = = = = = = = = = = = = No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.2/967 - Release Date: 8/22/2007 6:51 PM Yahoo! Groups Links This e-mail and any attachments may be confidential or legally privileged. [Non-text portions of this message have been removed] This e-mail and any attachments may be confidential or legally privileged. [Non-text portions of this message have been removed]
