<div>
<br />
&nbsp; Instead of Me.Recordset, you need to use whatever the report is using. &nbsp;If it's a table, name the table. &nbsp;If it's a query, name the query.<br />
<br />
&nbsp;You also could get the Dcount in code.<br />
<br />
JimD.
</div>



  Instead of Me.Recordset, you need to use whatever the report is using.  If it's a table, name the table.  If it's a query, name the query.

 You also could get the Dcount in code.

JimD.

<div>
Hi JDettman,<br />
<br />
I know that [RecordSource] can be used and that just gets whatever table or query is listed under that property.<br />
<br />
However, when I am opening the report using docmd.openreport, i specify a WHERE clause. So i actually need to work with the recordset you see, otherwise it will display all records for that table or query and I don't want that...
</div>


Hi JDettman,

I know that [RecordSource] can be used and that just gets whatever table or query is listed under that property.

However, when I am opening the report using docmd.openreport, i specify a WHERE clause. So i actually need to work with the recordset you see, otherwise it will display all records for that table or query and I don't want that...

<div>
Jim,<br />
<br />
I made a query to work around the problem.<br />
<br />
Thanks for the effort in assisting me with this problem.
</div>


Jim,

I made a query to work around the problem.

Thanks for the effort in assisting me with this problem.

<div>
<div class="content wysiwyg-content">
I am using this code in a ControlSource of a text box on a Report. It doesn't work as it doesn't like the syntax which states Me.Recordset. <br />
<br />
=DCount(&quot;SatisfactionRatin<wbr />g&quot;, Me.Recordset,&quot;Satisfaction<wbr />Rating = 1&quot;)<br />
<br />
Please advise if you know what would be correct syntax for the above function. Thanks.
</div>
</div>


I am using this code in a ControlSource of a text box on a Report. It doesn't work as it doesn't like the syntax which states Me.Recordset. 

=DCount("SatisfactionRating", Me.Recordset,"SatisfactionRating = 1")

Please advise if you know what would be correct syntax for the above function. Thanks.

Using Reports Recordset in a DCount Function

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.