sql ="SELECT DATEPART("yyyy",dates) FROM summary WHERE plants = '"& yieldsummary.cbPlant.Text&"'"
Hi, I am now want to retrieve only year from my table(summary),field name(dates). So i am facing the problem on how to display the year in combo Box. my sql statement as above. the error disply"No value given for one or more required parameters"Thanks
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
sandesh jPosted Nov 16, 2009, 4:40 AM
http://www.sqlusa.com/bestpractices2005/centurydateformat/
Blocked AccountPosted Aug 27, 2009, 5:21 AM
I think that error comes due to