Retriveve records on a special day

[Lurc]

Dear all,

VB.NET, Access 2000

How can prepare a sql statement to retrieve records on a special day? like

Select * from <table name> where workday='5/17/2005'

Thanks.

 

[Ken Tucker [MVP]]

Hi,

Select * from <table name> where workday=#5/17/2005#


Ken
------------------
Dear all,

VB.NET, Access 2000

How can prepare a sql statement to retrieve records on a special day? like

Select * from <table name> where workday='5/17/2005'

Thanks.