M
Mark J
Hello, i have the foloowing query in access;
SELECT dbo_AnalogHistory.DateTime, dbo_AnalogHistory.Tagname,
dbo_AnalogHistory.Value
FROM dbo_AnalogHistory
WHERE (dbo_AnalogHistory.TagName="FIR_301");
The problem is that the results i get back are for today, i want to query
for 12:00 am to 11:59:59 pm on the 11/25/2006?
but how do i put this in DateTime criteria?
ex.
[DateTime] [TagName] [Value]
criteria #11/26/2006# FIR_301 Is Not Null
but this does not work, any help would be welcome.
SELECT dbo_AnalogHistory.DateTime, dbo_AnalogHistory.Tagname,
dbo_AnalogHistory.Value
FROM dbo_AnalogHistory
WHERE (dbo_AnalogHistory.TagName="FIR_301");
The problem is that the results i get back are for today, i want to query
for 12:00 am to 11:59:59 pm on the 11/25/2006?
but how do i put this in DateTime criteria?
ex.
[DateTime] [TagName] [Value]
criteria #11/26/2006# FIR_301 Is Not Null
but this does not work, any help would be welcome.