Retriveve records on a special day

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.
--
Best regards,
RL


.

Relevant Pages

  • Re: Retriveve records on a special day
    ... How can prepare a sql statement to retrieve records on a special day? ... Best regards, ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • minumn and maximum
    ... what is the mininum and maximum value in SQL statement ... then it will show up all the value in table1 ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • [Info-ingres] FW: [Openroad-users] Obtaining SQL statement that was just perfor med
    ... Does anyone know how to obtain the SQL statement that was just performed? ... Regards ... Jade Clements ... Prev by Date: ...
    (comp.databases.ingres)
  • RE: minumn and maximum
    ... To show up all the values in the table you don't need to use the Where clause. ... min/max aggregate function inside a subquery, therefor you SQL Statement ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error messageORA-00979: not GROUP BY expression
    ... > I'm writing an application on a Oracle 8 database in combi with the ... The OLE DB provider is Microsoft for Oracle. ... > When I replace manually the parameter:BU to a string in the sql statement ...
    (borland.public.delphi.database.ado)