I've done such things with Access before (I'm pretty sure), and did so without issue. So I'm pretty sure you should be able to get it to work.
>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]
