no, Mark,
steve's after a count of unique values, which is different. Microsoft Access doesn't support COUNT DISTINCT. (At least, it didn't in Access 97 and I haven't got a later copy to try now) this is another way of skilling this Jet Cat: split it up... select COUNT(ColumnName) as theCount from (select DISTINCT(ColumnName) from tablename) another is to create a saved query (Access's simple "view") of the DISTINCT part and do a count on that. HTH barry.b > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark > Mandel > Sent: Tuesday, 5 April 2005 11:10 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Dam access > > > Shouldn't it be - > > SELECT DISTINCT > COUNT(...) > > or does that only work in Oracle? > > I've not touched Access in ages. > > Mark > > On Apr 5, 2005 10:06 AM, Steve Onnis <[EMAIL PROTECTED]> wrote: > > > > Is it possible to do COUNT(DISTINCT(ColumnName)) in access?? > > > > Steve > > > > -- > E: [EMAIL PROTECTED] > W: www.compoundtheory.com > ICQ: 3094740 > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
