What about SELECT Count(ColumnName) AS CountOfColumnName FROM tablename GROUP BY ColumnName;
Syntax tested in access and it does work Rob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Tuesday, 5 April 2005 10:06 AM To: CFAussie Mailing List Subject: [cfaussie] Dam access Is it possible to do COUNT(DISTINCT(ColumnName)) in access?? Steve --- 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/ __________ NOD32 1.1045 (20050404) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com --- 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/
