AFAIK I think you can only do distinct on 1 field. Try it with just one field - (not the key as this should be distinct anyway)
Kola > >-----Original Message----- > >From: cftalk [mailto:[EMAIL PROTECTED]] > >Sent: 22 March 2002 18:32 > >To: CF-Talk > >Subject: OT: count(distinct) in MS Access > > > > > >Hi, > > > >Is there any workaround or something to make Access SQL be able to do > >count(distinct col_name)? I have tried making a view and it takes a big > >hit in the time it takes the query to run. > > > >Thanks > > > >Chuck Rodgers > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
