Results 1 to 3 of 3

Thread: Multiple Search

  1. #1
    Join Date
    Mar 2004
    Location
    Atlanta, GA
    Posts
    58

    Unanswered: Multiple Search

    I can't find anything wrong with this statement, but it is not pulling up the records that I know are there.

    Code:
    strSQLSearch = "SELECT Inv_ID, StockNbr, VIn_Nbr, UnitStatus, Year, Make, Model, Color FROM tblInventory WHERE make = '" & Nz(Me.txtMake, "*") & "' AND model = '" & Nz(Me.txtModel, "*") & "' AND color = '" & Nz(Me.txtColor, "*") & "'"

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    apart from it being on one infinite length line so it's impossible to read?

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Don't be an ass.

    We get enough of that from end users.





    try using LIKE instead.

Posting Permissions

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