pcc
Well-known Member
- Joined
- Jan 21, 2003
- Messages
- 1,353
I am fairly new to Access SQL and cannot understand this.
I have a a table called 'Status' including this record
Filename Date Time
R2035009.MEA 14-Nov-07 23:14:16
If I run this query
SELECT * FROM Status
WHERE (filename = "R2035009.MEA") and (Date = #2007/11/14# ) and (time = #23:14:16#);
I get no records returned, but if I run this query
SELECT * FROM Status WHERE (filename = "R2035009.MEA") and (Date = #2007/11/14# ) and (time <> #23:14:16#);
then the record is returned.
I guess it's some sort of formatting problem but I don't know where to start.
Can anyone assist, please? :wink:
I have a a table called 'Status' including this record
Filename Date Time
R2035009.MEA 14-Nov-07 23:14:16
If I run this query
SELECT * FROM Status
WHERE (filename = "R2035009.MEA") and (Date = #2007/11/14# ) and (time = #23:14:16#);
I get no records returned, but if I run this query
SELECT * FROM Status WHERE (filename = "R2035009.MEA") and (Date = #2007/11/14# ) and (time <> #23:14:16#);
then the record is returned.
I guess it's some sort of formatting problem but I don't know where to start.
Can anyone assist, please? :wink: