Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group - Memo field error

Status
Not open for further replies.
IceRuby

IceRuby

Technical User
Jan 20, 2004
85
0
0
AU
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.
 
Sort by date Sort by votes
Sorry I should have added the data within the Access database was converted (& supplied) from SQL 2005.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
182
hilfy
hilfy
Gary Hnat
  • Locked
  • Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
151
Gary Hnat
Gary Hnat
CrystalUser90
  • Locked
  • Question
Same field on two tables, merge into one field on report 1
Replies
2
Views
143
CrystalUser90
CrystalUser90
jlr123
  • Locked
  • Question
linking primary table field
Replies
3
Views
45
kray4660
kray4660
whimsical_data
  • Locked
  • Question
Filter BLANK fields to show only
Replies
3
Views
46
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top