Date Search returning no records

Results 1 to 2 of 2

Thread: Date Search returning no records

  1. #1
    shaz Guest

    Default Date Search returning no records

    I`m using the Access97 database and my query looks correct but it is not returning any records. I know that records are there because I`ve ran a query in Access and I`ve checked the dates. Here is my line of code:<BR><BR>SQL = "SELECT * FROM Appointment WHERE #" & sd & "# = VisitDate"<BR><BR>It returns:<BR>SELECT * FROM Appointment WHERE #10/04/00# = VisitDate<BR><BR>I`ve tried entering the actual value instead of a variable but it still returns a blank page. Is there anything else that I should look for?<BR><BR>Many thanks. <BR>

  2. #2
    shaz Guest

    Default RE: Date Search returning no records

    Resolved - due to not using the &#039isdate&#039 function when I first entered the date it wasn&#039t being recognised as a date. Many thanks.

Posting Permissions

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