Microsoft Access SQL Query
Posted on 2014-07-24
Can I write an SQL query in MS Access 2002?
Specifically, "SELECT * from Workorder where DateEntered > 3/1/2014".
I am accustomed to using MySQL where the date is stored yyyy-mm-dd; not sure if the Access date format is correct as I stated it.
If I can do this, how do I build it (in Access) & Run it? Can I store the "result set" as a table?