Doris Manning
mikedorism at verizon.net
Wed Oct 25 12:59:36 CDT 2006
Click on the "Group By" button. Set the person information to "Group By" and set the calculated column to "Average". Doris Manning -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia Sent: Wednesday, October 25, 2006 1:53 PM To: accessd at databaseadvisors.com Subject: [AccessD] Calculating Date/Time I got the DateDiff in days - so how do I get the Average number of days it took to close for each person? >I would use the DateDiff function -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com