<div>
You might be able to construct a field by concatenating the results of two Min() and Max() Select statements, concatenated with a &quot;&nbsp;- &quot;&nbsp;string.<br />
<br />
Without more information and representative sample data, I would only be guessing.
</div>


You might be able to construct a field by concatenating the results of two Min() and Max() Select statements, concatenated with a " - " string.

Without more information and representative sample data, I would only be guessing.

<div>
Aikimark - I'm using Allen Browns Concatrelated function, How can I add the Min() and Max() to my Concat statement below?<br />
<br />
<br />
=IIf(IsNull([WINGS]),Null,<wbr />ConcatRela<wbr />ted(&quot;LL_NU<wbr />M&quot;,&quot;qry_ll<wbr />Join&quot;,&quot;WIN<wbr />GSID = &quot;&nbsp;&amp; [WINGS]))
</div>


Aikimark - I'm using Allen Browns Concatrelated function, How can I add the Min() and Max() to my Concat statement below?


=IIf(IsNull([WINGS]),Null,ConcatRelated("LL_NUM","qry_llJoin","WINGSID = " & [WINGS]))

<div>
I am unfamiliar with the Concatrelated function and your data.
</div>


I am unfamiliar with the Concatrelated function and your data.

<div>
<div class="content wysiwyg-content">
I have a report with a sub-form that will display all the doc numbers associated with each record:<br />
Record 1 <br />
Doc 1, Doc 2, Doc 3, Doc 4<br />
<br />
How can I update my report to:<br />
Record 1<br />
Doc 1 - Doc 4<br />
<br />
If not consecutive:<br />
Record 1<br />
Doc 1 - Doc 4<br />
Doc 8<br />
Doc 10 - Doc 20<br />
<br />
We can use the ID or Key for this purpose due to each doc number is consecutive with the key id. <br />
With the logic if more than 3 records (Doc 1, Doc 2, Doc 3) show range in lieu of each record.
</div>
</div>


I have a report with a sub-form that will display all the doc numbers associated with each record:
Record 1 
Doc 1, Doc 2, Doc 3, Doc 4

How can I update my report to:
Record 1
Doc 1 - Doc 4

If not consecutive:
Record 1
Doc 1 - Doc 4
Doc 8
Doc 10 - Doc 20

We can use the ID or Key for this purpose due to each doc number is consecutive with the key id. 
With the logic if more than 3 records (Doc 1, Doc 2, Doc 3) show range in lieu of each record.

MS Access How can I display a range in lieu of displaying every record in my 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.