SELECT DISTINCT and memo field problem? 
Author Message
 SELECT DISTINCT and memo field problem?

When I attempt to run this:
SELECT DISTINCT tblPermitReport.comment
FROM tblPermitReport;

I get the following message:
"The field is too small to accept the amount of data you attempted to
add.  Try inserting or pasting less data."

comment, is a field of type memo, it is not a linked table it is an access
table, the largest comment is 1572 character long.

Very annoying.  Anyone have any ideas?



Tue, 05 Aug 2003 05:19:31 GMT  
 SELECT DISTINCT and memo field problem?
This is the same as attempting to group by a memo field. This isn't possible
in a standard query. You could possibly write some code that would do this
or try limit your distinctness to 255 characters.
SELECT DISTINCT Left(tblPermitReport.comment,255) As ShortComment
 FROM tblPermitReport;


Quote:
> When I attempt to run this:
> SELECT DISTINCT tblPermitReport.comment
> FROM tblPermitReport;

> I get the following message:
> "The field is too small to accept the amount of data you attempted to
> add.  Try inserting or pasting less data."

> comment, is a field of type memo, it is not a linked table it is an access
> table, the largest comment is 1572 character long.

> Very annoying.  Anyone have any ideas?



Wed, 06 Aug 2003 02:39:35 GMT  
 SELECT DISTINCT and memo field problem?
Thank you.
Quote:

>This is the same as attempting to group by a memo field. This isn't possible
>in a standard query. You could possibly write some code that would do this
>or try limit your distinctness to 255 characters.
>SELECT DISTINCT Left(tblPermitReport.comment,255) As ShortComment
> FROM tblPermitReport;



>> When I attempt to run this:
>> SELECT DISTINCT tblPermitReport.comment
>> FROM tblPermitReport;

>> I get the following message:
>> "The field is too small to accept the amount of data you attempted to
>> add.  Try inserting or pasting less data."

>> comment, is a field of type memo, it is not a linked table it is an access
>> table, the largest comment is 1572 character long.

>> Very annoying.  Anyone have any ideas?



Sat, 09 Aug 2003 00:00:49 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Problem with Memo field in SELECT DISTINCT queries

2. Using SELECT DISTINCT with Memo field

3. Memo fields - problems reporting 2 memo fields

4. Select distinct on 1 field but returns multiple fields

5. DISTINCT with a memo field

6. select count(distinct field)

7. Append memo field to a different memo field

8. Problem using SELECT DISTINCT

9. Select Distinct Problem

10. Select Distinct problem

11. Select Distinct problem from VB

12. SELECT DISTINCT problem (adVarWChar VS. adLongVarChar)

 

 
Powered by phpBB® Forum Software