HOW TO FILTER DATA FROM MICROSOFT ACCESS

[joneschn]

HOW TO FILTER DATA FROM MICROSOFT ACCESS BASED ON DATE AND TIME AND GIVE THE RESULT TO A TABLE ?

I need some example files , can anybody please help me ?

[Dennis_Knutson · Accepted solution]

Please fix your keyboard. If it's not broken, be a little more polite and stop shouting.

The are thousands of examples on the web related to the jet database and sql queries. It is a very basic select statement. Access has a query wizard that can then show the sql code. If you don't know how to design a query in access, you need a basic tutorial for that. No LabVIEW issue here.

[mikeporter]

Just be sure to get examples specific to the Jet DBMS. It is rather "idiosyncratic" when dealing with time and date values.

One question: the timestamp is being saved in a datetime field, right?

Mike...