Group - Memo field error

[IceRuby]

Using Crystal XI connected to Access 2000 database.

I want to create a Group via selection of memo type field. The field I require is NOT displayed in fields I can group on.

Why is this? Do I need to convert field type?
Thanks in advance.

 

[IceRuby]

Sorry I should have added the data within the Access database was converted (& supplied) from SQL 2005.

 

[IanWaterman]

Generally the nature of a memo field is lots of uncommon data so why group on it?

If it does have common data try changing to varchar.

Ian

 

[chelseatech]

Create a formula to extract some of the memo field.
Left({table.memofield}, 40)

You should be able to group on that formula.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm