thanks for any help,

I have a small SQL query(shown below) that will retrieve some date from .mdb
according to the date selected. It will get the data greater then the data
selected or the date less or equel to selected date. I need to select between
two dates and get the data from that. Like I select 11/15/2005 00:00:00 to
11/31/2005 00:00:00 and only the data from those two dates are returned.

Thanks again for any help. darron


SQL Query-------------------------------------


SELECT TrendAnalogJoin.DateTime, TrendAnalogJoin.TagName,
TrendAnalogJoin.Value
FROM TrendAnalogJoin TrendAnalogJoin
WHERE (TrendAnalogJoin.DateTime'2005/10/28 23:59:00')
ORDER BY TrendAnalogJoin.DateTime