Text truncation in queries

[cubi]

Hi,

I am using Access 2003 and one of my queries returns truncated text -- truncated from the front. I use DISTINCT in my query. When I remove DISTINCT the texts look fine.

Has anyone seen this problem before?

Thank you!

 

[SkipVought]

Hi,

Could you explain? Please post an example of the SOURCE DATA, SQL, and the query results.

Skip,
[sub]
[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large! [/sub]

 

[PHV]

Has the original truncated text more than 255 characters ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dhookom]

Why can't you just leave the "Distinct" out of the query. Distinct is similar to Group By. You might want to try DISTINCTROW.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cubi]

The query is kind of long, but it looks like:

SELECT DISTINCT AGENCY_ID, PROGRAM_ID, ACTIVITY_ID, ... DESCRIPTION
FROM AGENCY, PROGRAM, ACTIVITY, ...
WHERE ...

I used DISTINCT to get unique values. The text value in the DESCRIPTION field es truncated.

Without DISTINCT the query returns 3 times as many rows due to duplication. I also tried DISTINCTROW, which eliminates some duplication, but not exactly what I want.

Thank you all for your input.

 

[PHV]

Without DISTINCT the query returns 3 times as many rows due to duplication
Even with JOIN clauses ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dhookom]

Use:
GROUP BY AGENCY_ID, PROGRAM_ID, ACTIVITY_ID, ...
With a column of First([Description]).

You could also try create the distinct query first without the Description field. Then create another query that is based on the distinct query and adds the table/query with the Description field.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.