multiple select

Results 1 to 2 of 2

Thread: multiple select

  1. #1
    Join Date
    Dec 1969

    Default multiple select

    I have a drop down box for branches. If a user selects multiple branches, i run a select query where branch IN (" & strBranch & "). This works fine but doesn&#039t work if only one branch is selected. How do I do a count to see if branch selected was one so I can write a query where branch = & strbranch &. I know there is a simple question, but due to time constraint , i am going blank<BR><BR>thnaks

  2. #2
    gh Guest

    Default RE: multiple select

    &#039IN&#039 should work with only one choice. It won&#039t work with zero, of course. Are you sure you aren&#039t emitting an extra comma or leaving off quotes or something? If you try the query using &#039=&#039 do you get results back? Maybe there aren&#039t any records with the one value.

Posting Permissions

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