syntax error

Results 1 to 2 of 2

Thread: syntax error

  1. #1
    zuri Guest

    Default syntax error

    i think i have a sintax error<BR>i want to take out data from table using two date&#039;s and a name<BR>i am having a problem with the name part (the dates are working)<BR>pleas corect me ,thank&#039;s from advanse zuri.....<BR>SQL = "SELECT dat,name FROM carreq WHERE dat BETWEEN #" & firstDate & "# AND #" & lastDate & "# and name Like &#039;%" & nam & "%&#039; "

  2. #2
    Join Date
    Dec 1969

    Default what RDBMS?

    it may effect it. I don&#039;t think BETWEEN is used like that, actually, but I&#039;m not going to check until I know what docs to look in.

Posting Permissions

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