ACCESS DATE/TIME Issue! Thanks!

[keledidi]

Hey guys, I imported some data(tables form in txt files) into access. However, when I am trying to get the data using "create queries" from access, i noticed that some of the data in the tables cannot be extracted using "create queries". Please help me out!



My SQL command is :

Select * from MinuteData where ContractID = 461 AND Date = #5/15/2012# AND Time = #9:14:00 AM#

but if such commands are entered in design view, it became something like

SELECT MinuteData.ContractID, MinuteData.Date, MinuteData.Time
FROM MinuteData
WHERE (((MinuteData.ContractID)=461) AND ((MinuteData.Date)=#5/15/2012#) AND ((MinuteData.Time)=#12/30/1899 9:14:0#));

[June7]

That query is not returning correct records? The Date and Time fields are Date/Time datatype? Try:

Select * from MinuteData where ContractID = 461 AND [Date] & " " & [Time] As DateTime = #5/15/2012 9:14:00 AM#;

[keledidi]

That query is not return correct records? The Date and Time fields are Date/Time datatype? Try:

Select * from MinuteData where ContractID = 461 AND [Date] & " " & [Time] As DateTime = #5/15/2012 9:14:00 AM#;

Thanks a lot. Let me try it!

[keledidi]

That query is not return correct records? The Date and Time fields are Date/Time datatype? Try:

Select * from MinuteData where ContractID = 461 AND [Date] & " " & [Time] As DateTime = #5/15/2012 9:14:00 AM#;

Doesnt work
saying some "syntax error" in query expression.

[June7]

I tested both syntax and they work. Must be something about your data. Want to provide db for analysis? Follow instructions at bottom of my post.

[keledidi]

I tested both syntax and they work. Must be something about your data. Want to provide db for analysis? Follow instructions at bottom of my post.

Thanks man. I will check it again when i am back to office tomorrow.

[keledidi]

I tested both syntax and they work. Must be something about your data. Want to provide db for analysis? Follow instructions at bottom of my post.

It works now! Thanks!