I think this is right.... An Access DISTINCT = DISTINCTROW ie
ACCCESS only accepts SELECT DISTINCT [combination of values of all columns in each row you are outputting] This is not such a big problem (unless it is a subquery) as you can do a SELECT DISTINCT count(unique_keyvalue) AS mycount, column_name(s)_containing_values_you_want_to_be_distinct cftalk wrote: > > 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 > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
