Thanks! That worked beautifully. Dave ________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Saturday, August 25, 2007 1:14 AM To: [email protected] Subject: RE: [ms_access] Memo Field truncated in query result Dave- If you're trying to list the details and then get a grand total of the failures, use your query in a report, add a Report Footer, and include a text box that uses the Sum function. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals http://www.viescas.com/ <http://www.viescas.com/> (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ <http://blogs.msdn.com/access/> -----Original Message----- 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 10:40 PM To: [email protected] <mailto:ms_access%40yahoogroups.com> Subject: RE: [ms_access] Memo Field truncated in query result John...I took the toals out entirely....I was trying to get it to indicate 1 for each "failed" test....and then total the "1s" I found a better way to do it, cancelled the Totals by Group, and immediately got my memo field to quit truncating. ALl is well now...perhaps not perfect since I am a neophyte, but as always, I sincerely appreciate everyone's help. Dave ________________________________ From: [email protected] <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ] On Behalf Of John Viescas Sent: Friday, August 24, 2007 3:25 PM To: [email protected] <mailto:ms_access%40yahoogroups.com> Subject: RE: [ms_access] Memo Field truncated in query result Dave- >From looking at your original SQL, it's unlikely that you'll ever get a count of more than 1 unless you have lots of duplicate rows in your data. What is it you're really trying to accomplish? John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals http://www.viescas.com/ <http://www.viescas.com/> <http://www.viescas.com/ <http://www.viescas.com/> > (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ <http://blogs.msdn.com/access/> <http://blogs.msdn.com/access/ <http://blogs.msdn.com/access/> > -----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 9:54 PM To: [email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> Subject: RE: [ms_access] Memo Field truncated in query result Yes. I had totals on...my fault...I removed totals and the field is no longer truncated. Thanks! I'll figure out another way to accomplish the totals. Dave ________________________________ 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 Brodeur, Rich Sent: Friday, August 24, 2007 2:23 PM To: [email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> 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:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> <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> <mailto:ms_access%40yahoogroups.com> <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:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> <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> <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:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> <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> <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] Yahoo! Groups Links This e-mail and any attachments may be confidential or legally privileged. [Non-text portions of this message have been removed] Yahoo! Groups Links This e-mail and any attachments may be confidential or legally privileged. [Non-text portions of this message have been removed]
