[AccessD] date query

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




More information about the AccessD mailing list