Thanks,
That worked beautifully!!!!!!!!!!!!!
Julie
>From: "Norman Elton" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Simple Access Query Help
>Date: Thu, 07 Jun 2001 10:33:04 -0400
>
>How about:
>
>SELECT Avg(DateDiff("n",BegTime,EndTime)) AS AvgLength FROM Meetings WHERE
>DatePart("yyyy",BegTime) = 2000 GROUP BY Site
>
>That should return the average time in minutes.
>
>Hope this helps
>
>Norman
>
>-----Original Message-----
>From: Julie Clegg [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, June 07, 2001 10:11 AM
>To: CF-Talk
>Subject: Simple Access Query Help
>
>
>
>Hello,
>
>Can anyone help me with this simple query...? I have a "Meeting Table"
>which stores the begining time and ending time of each meeting conducted,
>per site. I need to write a query to calculate the average
>meeting time per site for the year 2000. Below is an example of my table:
>
>MeetingNumber BegTime EndTime Site
> 1 2:15am 3:00am 3
> 2 12:30pm 1:05pm 3
> 3 6:53am 12:08pm 9
>
>
>Thanks In Advance!!!!!!!!!!
>
>Julie
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
