# is the delimiter used by Access.
For SQL, you can use the quote (') like this:
select * from person_registration_details where expiry_date='2002-07-06'
>hello everybody
>i have a problem with vb & sql server7 all the code is working fime but whenever i tried to select a records on the basis of date ,it returned empty recordset, i tried using using '#' and 'datevalue' function but the result is same please help me
>the query written by me is
>select * from person_registration_details where expiry_date=datevalue(date)
>thanks in advance
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com