Make another field that contains a snippet of the memo field if you want to use it in that way.
russ > -----Original Message----- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: 18 August 2004 11:10 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OT: Access queries > > > a colleague of mine (two actually) has reliably informed me > that you can't group on memo fields!? > > _______________________________________________________ > Regards, > > Richard Lovelock > Senior Application Analyst > > Westminster City Council - Web Support > Capgemini UK > Southbank > 95 Wandsworth Road > London > > SW8 2HG > > Tel: 0870 906 7482 > > > > -----Original Message----- > From: Giles Roadnight [mailto:[EMAIL PROTECTED] > Sent: 18 August 2004 10:58 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OT: Access queries > > > Don't think so - I', not retrieving much data at all. It is > also not the CF admin set up as I get the same problem when I > run it in Access. > > I've been told that this is what Access does to memos when > they are grouped. I'll just have to run 2 queries. > > Giles Roadnight > http://giles.roadnight.name > > > -----Original Message----- > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > > Sent: 18 August 2004 10:31 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OT: Access queries > > Are you exceeding the max number of characters per row. > In SQL server you cannot have more than 8000 characters per > row of data, unless you use BLOBS. > I would imagine Access is similar. So any data beyond this > gets chopped. > > russ > > > > -----Original Message----- > > From: Giles Roadnight [mailto:[EMAIL PROTECTED] > > > Sent: 17 August 2004 21:52 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] OT: Access queries > > > > > I have two tables: news and comments. I have written a query > > > that returns the news records with a count of the number of > > > comments there are for each story. > > > > > This all works fine but as I am grouping the newsContent > > > field I am only getting the first 255 (that's what it looks > > > like anyway) characters (it is a memo field). > > > > > How do I get around this? I know Access is quite limited but > > > this is ridiculous! I must be able to count the number of > > > comments and return the whole story! > > > > > Thanks > > > > > Giles Roadnight > > http://giles.roadnight.name > > > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > > > http://forum.cfdeveloper.co.uk/ > > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > CFDeveloper Sponsors and contributors:- *Hosting and > support provided > > by CFMXhosting.co.uk* :: > > > *ActivePDF provided by activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow > > > provided by proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists > > > hosted by gradwell.com* > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > -- > > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > Our name has changed. Please update your address book to the > following format: "[EMAIL PROTECTED]". > > This message contains information that may be privileged or > confidential and is the property of the Capgemini Group. It > is intended only for the person to whom it is addressed. If > you are not the intended recipient, you are not authorized > to read, print, retain, copy, disseminate, distribute, or > use this message or any part thereof. If you receive this > message in error, please notify the sender immediately and > delete all copies of this message. > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
