select statement using dates...

Results 1 to 2 of 2

Thread: select statement using dates...

  1. #1
    Join Date
    Dec 1969

    Default select statement using dates...

    select * from Contact, Event where Contact.Cont_ID = Event.Fkey_ContactID and Event.Evt_Start_Date = 9/25/2001 <BR><BR>is my select statement in my code...however, it doesn&#039;t return a **** thing (i know there&#039;s data in there for that particular date)...what&#039;s the deal??? i&#039;m using an access backend. should i delimit the date with special characters or that it?<BR><BR>hellllllllllllllllllp me! please...

  2. #2
    Join Date
    Dec 1969

    Default RE: select statement using dates...

    in Access you should delimit the date with brackets (#), see the manual.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts