# Report builder Question? (assigning record #s)

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2000-09-05 09:07 UTC
**Views:** 339
**Replies:** 0
**URL:** https://www.epiusers.help/t/report-builder-question-assigning-record-s/1016

---

## Post #1 by @system

<div id="ygrps-yiv-788481241">How about setting up an aggregate field that will count the records?  Pick a<br/>
field that is in the record line and have the aggregate count on that field.<br/>
I use that when I want to calculate averages...<br/>
<br/>
Gary Grenier<br/>
Bell Manufacturing Co.<br/>
<a rel="nofollow" target="_blank" href="mailto:ggrenier@...">ggrenier@...</a><br/>
<br/>
<blockquote><span title="qreply"> &gt;    From: &quot;Jim Stetter&quot; &lt;<a rel="nofollow" target="_blank" href="mailto:jimstetter@...">jimstetter@...</a>&gt;<br/>
&gt; Subject: RE: Report builder Question?<br/>
&gt;<br/>
&gt;   If you could somehow assign each record a record#, then you could do a<br/>
&gt; calculated field using<br/>
&gt;   iif(Recno = 1, 0, (Recno - 1) MODULO (#of columns)), then sort by the<br/>
&gt; calculated field and Recno.<br/>
&gt;   This would sort the records such that for columns=3; records 1,4,7...<br/>
&gt; would =0; records 2,5,8..=1... effectively transposing the rows into<br/>
&gt; columns.  Like Wayne, I have not figured out how to assign a record #.<br/>
&gt;   Regards<br/>
&gt;   Jim Stetter </span></blockquote></div>

---


**Canonical:** https://www.epiusers.help/t/report-builder-question-assigning-record-s/1016
**Original content:** https://www.epiusers.help/t/report-builder-question-assigning-record-s/1016