memo field truncates in query using group by or unique values

  • Thread starter Thread starter connie
  • Start date Start date
C

connie

I am trying to run a query against a base table to
identify unique values. However, when I use the group by
and/or the unique values options a MEMO field in my query
truncates to 255 characters.

I've tried using the unique records to achieve this;
however, I receive an error message relating to the field
being to small. The max record length in the column
defined as memo is 1099.

I'm running Access 2000.

I need to know how if there is a way to prevent the memo
field from truncating when using group by or unique
values; or is there another way I can accomplish this....
any assistance is greatly appreciated appreciated.

Thanks,
Connie
 
In the Total row of your GROUP BY query, under the memo field, try:
First

This tells Access just to grab the memo field for first matching record it
finds, and since it does not have to read the value and compare it to others
(as it must if you GROUP BY the memo field), it is free to return the whole
thing.
 
It worked! Thanks a million!
-----Original Message-----
In the Total row of your GROUP BY query, under the memo field, try:
First

This tells Access just to grab the memo field for first matching record it
finds, and since it does not have to read the value and compare it to others
(as it must if you GROUP BY the memo field), it is free to return the whole
thing.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
Back
Top