does anyone have a good sample of SQL code that does in essence the following:
A. takes and groups the total records on a per date basis where the date is a date/time field.. so we want Jan 11, Jan 12, Jan 13, etc. broken out... (yeah we store date and time.. much easier if we would have stored time in another field)... so only group where records exist for day.. B. Calculates the total number of records found for each date... so Jan 11 = 21, Jan 12=31... an Access database sort of SQL piece will be fine... sounds simple... perhaps I should get some rest and come back... :) ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
