I would write a query that looks like so
SELECT meetingnumber, EndTime - BegTime AS Lenghtofmeeting, site
from meeting;
Then query that query like so
SELECT AVG(lenghtofmeeting) AS averagemeetinglenght
from length;
You could use views here but access won't let you so you have to query a
query.
JLB
-----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
