<div>
Well you can do TOP N like this (example) ... but not sure if this is what you want<br />
<br />
SELECT <b>TOP 20</b> Table1.[RISK Level]<br />
FROM Table1<br />
ORDER BY Table1.[RISK Level] <b>DESC</b>
</div>


<div>
It would work if I was just doing top 20. &nbsp;But I'm trying to &nbsp;do it for each class,<br />
<br />
for example, if there are 5 classes, I want to return 100 rows.
</div>


<div>
Add a where clause to the RecordSource query of the subform and reference the Class<br />
<br />
SELECT TOP 20 Table1.[RISK Level]<br />
FROM Table1<br />
Where Class = Forms!yourform!txtClass<br />
ORDER BY Table1.[RISK Level] DESC
</div>


<div>
That's what I thought ... <br />
Well ... I can't do this right now (meeting) but someone should be along to help.<br />
<br />
In SQL Server it would be easy ... as I just learned :-)
</div>


<div>
Hi Pat wouldn't that just bring up one class not all of them?
</div>


<div>
How many classes is your main form showing? &nbsp;A form can show only a single record at a time and since unless you are using MVF's, the record can contain only one class value, the subquery should work. &nbsp;The class it looks for will change as you scroll through the main form records.
</div>


<div>
Gustav, I think that's pretty close. &nbsp;Is there a way, I can autoassign a unique id in the preceding query?
</div>


<div>
Thank you very much. &nbsp;This helped a lot.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a query that pulls up the values that are related to CLS_REF1 in a query called &nbsp;Dashboard Style Query - Class Combined YoY<br />
<br />
I was wondering if it's possible to only bring up the top 20 values(STYLES) of each CLS_REF1 in a query called <br />
Dashboard Style Query - Style Combined YoY. &nbsp;<br />
Using a subreport is taking too long.<br />
<br />
Thanks.
</div>
</div>


Hello,

I have a query that pulls up the values that are related to CLS_REF1 in a query called  Dashboard Style Query - Class Combined YoY

I was wondering if it's possible to only bring up the top 20 values(STYLES) of each CLS_REF1 in a query called 
Dashboard Style Query - Style Combined YoY.  
Using a subreport is taking too long.

Thanks.

Access Query Top 20 from subquery

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.