[2008] HELP HELP HELP... selection of DATA by rangeof date.

[bizzy_e23]

In VB 6.0 im just using (select * from table where date between date1,date2) or (select * from table where date > date1 and date < date2)

how about in VB.net????

[Lerroy_Jenkins]

Firstly, putting HELP HELP HELP is probably more likly to put people OFF helping you.

We assume that you are posting a thread inorder to recieve help.

Okay, is this a SQL Quiery? or where are you trying to get all of this information from?

[bizzy_e23]

Im so sorry about that... thanks for the advise


Actually Im using Access as my back end, I'm just using queries in retrieving information but if you have a brigther idea on retrieving data, pls do so. THANKS

[jmcilhinney]

The SQL code is executed on the database so the programming language is irrelevant. Whatever SQL works in VB6 will work in VB.NET too if it's executed on the same database via the same provider. How you execute SQL statements against a database is different though. Follow the Data Access link in my signature for some ADO.NET examples.