Results 1 to 3 of 3

Thread: Select Where

  1. #1
    Join Date
    Mar 2004
    Posts
    79

    Unanswered: Select Where

    Help!

    What am I doing wrong?

    "SELECT tblInvoiceHdr.InvoiceNumber, tblCustomers.CustName," & _
    "tblInvoiceHdr.Date FROM tblCustomers RIGHT JOIN tblInvoiceHdr ON " & _
    "tblCustomers.CustNumber = tblInvoiceHdr.BillToNumber " & _
    "WHERE tblInvoiceHdr.Posted <> 'Y' ORDER BY tblInvoiceHdr.InvoiceNumber;"


    It works fine until I put the Where tlbInvoiceHdr.Posted <> 'Y'. But I need to narrow the search using this data selection.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    "WHERE tblInvoiceHdr.Posted <> 'Y'" will not select records where that column is NULL.

  3. #3
    Join Date
    Mar 2004
    Posts
    79
    Thank You...I changed to ..."WHERE tblInvoiceHdr.Posted Is Null" and it works fine.

Posting Permissions

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