<div>
rs.open &quot;SELECT COUNT(*) AS C1 FROM Table1 WHERE ID&gt;100&quot;<br />
msgbox rs!C1<br />

</div>


rs.open "SELECT COUNT(*) AS C1 FROM Table1 WHERE ID>100"
msgbox rs!C1


<div>
Is rs a collection? please be more specific.<br />

</div>


Is rs a collection? please be more specific.


<div>
rs is the recordset you execute the query on. You didn't specify the data access method you are using, so that was a general example. Anyway, no matter what you are using, execute that statement, and you'll get the results.<br />

</div>


rs is the recordset you execute the query on. You didn't specify the data access method you are using, so that was a general example. Anyway, no matter what you are using, execute that statement, and you'll get the results.


<div>
When dim the rs as a recordset I still get error messages. rs.open will not work, nor will rs.openrecordset<br />

</div>


When dim the rs as a recordset I still get error messages. rs.open will not work, nor will rs.openrecordset


<div>
What data access method are you using?<br />
DAO/RDO/ADO?<br />

</div>


What data access method are you using?
DAO/RDO/ADO?


<div>
Please paste your query as a comment here.<br />

</div>


Please paste your query as a comment here.


<div>
should be msgbox rs!x<br />

</div>


<div>
<div class="content wysiwyg-content">
I have written a select query that finds a count, how can I display this count in a message box to inform the user?
</div>
</div>


I have written a select query that finds a count, how can I display this count in a message box to inform the user?

Select query in VB

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.