Mike & Doris Manning
mikedorism at adelphia.net
Fri Sep 24 21:34:00 CDT 2004
Your first problem is probably the use of "Date" as a variable when it is a Reserved word. The syntax you are looking for is something like this... SELECT Avg(Temperature) AS AvgTemp FROM tblMeasure1 WHERE [Date] BETWEEN #...# AND #...# Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen Sent: Friday, September 24, 2004 5:30 PM To: AccessD at databaseadvisors.com Subject: [AccessD] date query Hello Group, i have a table [tblmeasure1] and important for the query are two fields: Date and Temperature. I am trying to get avg, min etc. etc from Temperature in certain date periods (Between #...# and #....#. But i keep running into errors. What is the right way to do this? Thanks Pedro Janssen Cytologist -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com