SQL Query, dates,between

Results 1 to 2 of 2

Thread: SQL Query, dates,between

  1. #1
    Join Date
    Dec 1969

    Default SQL Query, dates,between

    I&#039;m trying to do a query using 2 dates, and a between clause<BR>This is what i have, why doesn&#039;t it work?<BR>SQL = "select roomno from reservations where #" & ArrDate & "# between ArrDate and DepDate "<BR>

  2. #2
    Join Date
    Dec 1969

    Default Doesn't work means?

    Any error messages?<BR>What is ArrDate?<BR>What does the sql statement look like (after concatenation) ?

Posting Permissions

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