Hi everyone: I have an Access database. I have a date field (dateadded) w date & time in a table (activity). i want an SQL to create a table to count entries by dateadded (just the date part). something like: select count(*) as ctcount, ???(dateadded) from activity group by dateadded order by dateadded I could do this using a combination of access and cold fusion, but would rather just have an SQL do the work. any thoughts? thanks Sandy Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
