>Hi,
> I am using Access as my DB. However, I use Data Environment to query.
>How to do so?
Open Access to build your query. Once it will be done there, you will be able to copy and paste your query from Access to VB.
You could also, from VB, create a command (from the Data Environment). From there you have a button called SQL Builder that you can use to create queries (much like the one from Access).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com