<div>
Please clarify. What database are you using, and what scripting language?
</div>


Please clarify. What database are you using, and what scripting language?

<div>
I mentioned Access database in the question.<br />
Sorry, forgot to mention ASP and VBScript
</div>


I mentioned Access database in the question.
Sorry, forgot to mention ASP and VBScript

<div>
<div class="content wysiwyg-content">
I am using a Yes/No checkbox in my access DB and want to display all records on a page which have checkbox ticked.<br />
<br />
rsItem.Source = &quot;SELECT * FROM tblItem WHERE ItemYesNo = '1' ORDER BY ItemRef ASC&quot;<br />
<br />
The above code doesn't work.<br />
Any suggestions? <br />

</div>
</div>


I am using a Yes/No checkbox in my access DB and want to display all records on a page which have checkbox ticked.

rsItem.Source = "SELECT * FROM tblItem WHERE ItemYesNo = '1' ORDER BY ItemRef ASC"

The above code doesn't work.
Any suggestions? 


Check Box SQL

Adobe Dreamweaver is a web development tool featuring both WYSIWYG and code editors that allow the user to quickly and easily build websites in a wide variety of languages, including ASP, ASP.NET, ColdFusion and PHP. It also offers support for CSS and JavaScript.