what DB? +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----Original Message----- From: Nicholas Bourgeois [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 12:43 PM To: CF-Talk Subject: SQL: Average Orders Per Day I need to construct a SQL statement to get the average number of orders per day, but I can't figure it out. The table name is "orderSummary" and the date field is named "ordDate." Nick ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists