Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    14

    Unanswered: syntax error with this code

    here's my code:

    strSQL4 = "Select * From Transaction Where Barcode='" & Me.TxtCode & "' And EntryDate=#" & Me.ccDate & "# And TimeOut!=NULL"

    I got error when I tried to add the "And TimeOut!=NULL" anyone can help? thanks in advance!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    try AND TimeOut IS NOT NULL
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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