>surely , i work it fine on Access Query with one "#' at the front and end of the date. But it seems doesn't work on VB, am i right?
# is working very well in VB for dates stored in Access. If you copy the query as-is from Access to VB, it needs to work. If it doesn't, you have another problem. Show the code.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com