"Sort By" question - Please Help!!!

Results 1 to 2 of 2

Thread: "Sort By" question - Please Help!!!

  1. #1
    Join Date
    Dec 1969

    Default "Sort By" question - Please Help!!!

    I&#039;m trying to bring up a field in my database on the web. I want to grab only the records which contain the word "open". Here&#039;s my code which works fine...<BR><BR>[tablename].[recordname] FROM [tablename] WHERE (((tablename.recordname)=&#039;open&#039;))"<BR><B R>BUT ---<BR>What if I want to grab not only all records that say "open" in that field, but also "Hold" and "Pending". Any ideas????

  2. #2
    Join Date
    Dec 1969

    Default Use IN

    WHERE tablename.recordname IN (&#039;open&#039;, &#039;hold&#039;, &#039;pending&#039;)

Posting Permissions

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