2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by kaippilly
0

Make a select query with a WHERE clause pointing to the date. In the code below I assume your Adodc object's name is Adodc1

Adodc1.CommandType = adCmdText
Adodc1.Rcourdsource = "SELECT * FROM table1 WHERE Date = #" + yourdate + "#"
Adodc1.Refresh

Note that the # sign tells the database that you are sending a date and "yourdate" is a variable containing the date to be selected.

Edited by faroukmuhammad: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.