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]
