Ms access select data greater than datetime range

ms-access datetime ms-access-2007
Spen D picture Spen D · Dec 7, 2012 · Viewed 26.8k times · Source

How to select Data in ms access above this datetime range

like select * from logevents where logTime>='12/6/2012 3:54:15 PM'

logTime is Datetime field

Answer

HelloW picture HelloW · Dec 7, 2012

Adding # signs on each end of your date lets Access know that this is a date type.

select * from logevents where logTime>=#12/6/2012 3:54:15 PM#

Related questions

C# OleDbParameter with Access DateTime query

I have the following query that works from inside Access or from C# as an OleDbCommand: SELECT Table1.ProductType, Sum(Table1.ProductsSold) FROM Table1 WHERE (Table1.DateTime Between #5/16/2013# And #5/17/2013#) GROUP BY Table1.ProductType; Table1.DateTime is Date/Time data type. …

Read More
How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More
How to SUM two fields within an SQL query

I need to get the total of two fields which are within the same row and input that number in a field at the end of that same row. This is my code. Sum(tbl1.fld1 + tbl1.fld2) AS [Total] …

Read More