Group By truncates text

  • Thread starter Thread starter Rohan via AccessMonster.com
  • Start date Start date
R

Rohan via AccessMonster.com

I have a query where I group by a text field that is quite large, in order to
get a count for one of the other
variables. Access seems to truncate the text field.

Any clues ? Solutions ?

Rohan.
 
Rohan said:
I have a query where I group by a text field that is quite large, in order to
get a count for one of the other
variables. Access seems to truncate the text field.

Any clues ? Solutions ?

Rohan.
Click to expand...

Sorry - that should be a memo field not a text field.
 
Yes, Access will truncate a memo field at 255 characters if you try to group
by it.

If you actually expect Access to perform the string comparisions required to
cross-check thousands of characters at every record and so group by the
entire memo, you will be disappointed. Even if it could do that, performance
would be woeful.

If you just need the entire memo field returned (not actually grouped), use
First instead of Group By in the Total row of your query.
 
Allen said:
Yes, Access will truncate a memo field at 255 characters if you try to group
by it.
Click to expand...
If you just need the entire memo field returned (not actually grouped), use
First instead of Group By in the Total row of your query.
Click to expand...

I tried this and now it prompts me for the memo field.

Rohan.
 
Rohan said:
I tried this and now it prompts me for the memo field.

Rohan.
Click to expand...

Oh it's ok - I fixed it.

Thank you for all of your help,

Rohan.
 
Back
Top