<div>
Post what is in the report's record Source and filter properties. 
</div>


Post what is in the report's record Source and filter properties.

<div>
<div class="content wysiwyg-content">
I am creating a report where each record may be repeated multiple times under a different group. &nbsp;I would like to have a field that will sum the number of unique records, as each record may be repeated multiple times.<br />
<br />
I put this text box in the header with control source set to:<br />
=count(distinct[recordID] &nbsp;where recordID is the unique record Identifier on the master table, but was unable to gain a result.<br />
<br />
Please advise.<br />
<br />
Thanks, mark
</div>
</div>


I am creating a report where each record may be repeated multiple times under a different group.  I would like to have a field that will sum the number of unique records, as each record may be repeated multiple times.

I put this text box in the header with control source set to:
=count(distinct[recordID]  where recordID is the unique record Identifier on the master table, but was unable to gain a result.

Please advise.

Thanks, mark

count unique records on a report

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.