2 ratings:

3 out of 5

Rate this Document

How do I Specify a Date Search with Access 97 and the SQL Toolkit?

Primary Software: LabVIEW Toolkits>>Enterprise Connectivity Toolset
Primary Software Version: 3.0
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem: I would like to return all the records in my Access 97 database table that fall within a specified date range using the SQL toolkit in LabVIEW or CVI. What would be the correct syntax to implement the date criteria parameter?

Solution: The syntax you need to use for returning, say, all records between December 5-10, 1998 would be:

SELECT Column1 FROM TableName WHERE Column1 BETWEEN DateValue('12/5/98') AND DateValue('12/10/98').

For more information about Access specific syntax (or date literals), please refer to the Dblist96.hlp file located in your \Windows\Help directory.

Related Links:

Attachments:





Report Date: 11/18/1998
Last Updated: 12/02/2004
Document ID: 1FHGA42I

Your Feedback!	Poor  |  Excellent							Yes	No
Document Quality?							Answered Your Question?
	1	2	3	4	5
Document needs work? Please tell us why.
Please Contact NI for all product and support inquiries.