467,179 Members | 1,213 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,179 developers. It's quick & easy.

Query Truncates Memo Fields

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
  • viewed: 3231
Share:
2 Replies
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********@gmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.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
Thanks. This is working great.
Jacob

Feb 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by jimmyshaw83@gmail.com | last post: by
reply views Thread by Phil C. | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.