Query Truncates Memo Fields - Microsoft Access / VBA

jacoballen

I have a query that combines the results of three related tables. The
memo fields are truncated to 255 characters, but I need all the
information in them. I'm aware that removing code such as DISTINCT and
GROUPBY will fix this problem (as discussed in other threads in this
group), but I need to limit the query results to unique values, which
is what DISTINCT does for me. Any suggestions?
Thanks,
Jacob

Feb 16 '06 #1

Subscribe Reply

3593

Allen Browne

In a GROUP BY query, you can get the whole memo field by choosing First
instead of Group By in the total row under your memo field.

For a query that uses DISTINCT, omit the memo fields. Save the query. Then
use it as a source "table" in another query, joined to the one that contains
the memo. Since this new query is not using DISTINCT, you can now pull in
the entire memo field.

If you are actually trying to de-duplicate based on the contents of the memo
fields, you are out of luck. Access will compare the first 255 characters of
the memo only.

--
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.

<ja********@gma il.com> wrote in message
news:11******** *************@g 47g2000cwa.goog legroups.com...

I have a query that combines the results of three related tables. The
memo fields are truncated to 255 characters, but I need all the
information in them. I'm aware that removing code such as DISTINCT and
GROUPBY will fix this problem (as discussed in other threads in this
group), but I need to limit the query results to unique values, which
is what DISTINCT does for me. Any suggestions?
Thanks,
Jacob

Feb 16 '06 #2

jacoballen

Thanks. This is working great.
Jacob

Feb 16 '06 #3

Similar topics

10214

Memo field truncated in query/report?

by: GorDon | last post by:

Hi, I have a report based on a query. The query grabs a memo field from my main table, yet when I display the memo field in the report it truncates the memo field (the field needs to hold more than 255 characters). The table holds all the memo text, but the query seems to truncate the memo field to 255 chars? This seems like there should be a relatively easy fix, but I can't seem to find it.

Microsoft Access / VBA

5232

List Box Column to Memo truncates at 255 characters

by: Bob Dydd | last post by:

Hi Everybody I have a Listbox that has a Memo field attached to it's 2nd column which on double click copies the memo field to another Memo Field. Forms!! = ListClassification.Column(1) My problem is that the receiving Memo Field Truncates at 255 characters

Microsoft Access / VBA

1605

Union Query Truncates Memo Fields

by: jimmyshaw83 | last post by:

I am sorry if this topic is tired, but after all that I have read I am still in the woods here. I have built a database to handle weekly and monthly reports of what people are doing. They submit what they are working on and then you input a date and the info is narrowed allowing a report to be created containing all of the memo fields submitted during those dates. My Source Query gets all the memo fields in their entirety (greater than...

Microsoft Access / VBA

4103

Select query truncates memo field

by: Anna | last post by:

Hi all, I have a query in ASP.NET that selects text from a memo field in Access (among other things). The query appears to be truncating the text at 255 characters. I've done a little research on this and found some other Google Groups threads that were helpful, but I still don't have a solution. My query is rather complicated and uses a union, but not the keyword distinct. The query is displayed in a datagrid, and I don't know how I...

Microsoft Access / VBA

2595

Word truncates Memo field when using Automation from Access

by: Laurie | last post by:

I am using Automation in Access 2003 to open a Word Document and fill in some values using bookmarks. It all works perfectly except for one section. I am filling in some values in a previously created Word Table, and the memo fields are truncating to 255 characters. If I "manually" copy the memo field into the Table, it has no problem accepting more than 255 characters. Any suggestions on how to resolve this?

Microsoft Access / VBA

2771

Query - Mid Function & Mail Merge

by: Phil C. | last post by:

Hi, I'm using Access 2000. I have a Select Query that uses the MID function to separate the actual text of articles from the title of the articles. The articles are enterd into the underlying table (in a memo field) in html format, as one big block of text. The memo field is called (I named it before I realized that I needed to separate title from text).

Microsoft Access / VBA

6958

Chinese chars output from query??

by: Jeff | last post by:

A client showed me this one. In a totals query that counts items and links to a parent record, what should be the output from a memo field shows up as Chinese characters - I kid not. He has a parent record that contains some base info, date etc and a Memo field for notes. In a related table are details of items. He wanted to count the items for a particular header record so linked the two tables on the id and in the query grouped on...

Microsoft Access / VBA

2279

Select Query - Truncates Memo Field

by: cherylwalsh35 | last post by:

I am working in access - using a select Query. I am including a memo field. The table has all of the data in the memo field displayed - however when I run a select query and include the memo field - the data is truncated. Any ideas?

Microsoft Access / VBA

7284

Ignoring criteria in a query if the field is Null

by: seagullino | last post by:

Hello, I've developed my first Form, a simple affair that enables the user to search text in the memo fields in our database. When the "search" button is pressed, it runs a macro which runs the simple query. I have added a second field to the form, in addition to the text search field. This new field allows the user to type in an identification number, which returns all of the memo fields associated with that particular client. If the...

Microsoft Access / VBA

10230

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10004

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9870

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8886

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6678

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5313

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3972

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3576

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2817

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General