<div>
perfect, have many thanks for the prompt answer<br />
rgds<br />
Kongta
</div>


perfect, have many thanks for the prompt answer
rgds
Kongta

<div>
If that does not work, try saving the two parts of the UNION query seperately and writing your UNION query like this:<br />
<br />

<pre><code id="code-20-37850492-1">SELECT IQ,  Index, Anzeige
FROM qryTop5
UNION
SELECT IQ,  Index, Anzeige
FROM qryLast10</code></pre>
</div>


If that does not work, try saving the two parts of the UNION query seperately and writing your UNION query like this:



SELECT IQ,  Index, Anzeige
FROM qryTop5
UNION
SELECT IQ,  Index, Anzeige
FROM qryLast10

<div>
<div class="content wysiwyg-content">
I would like to show the Top10 &amp;&nbsp;Last 5 of a table in one query. I tried<br />
<br />
SELECT TOP 5 dbo_tblStatistikTmp_sb_Ind<wbr />ex.IQ, dbo_tblStatistikTmp_sb_Ind<wbr />ex.Index, dbo_tblStatistikTmp_sb_Ind<wbr />ex.Anzeige<wbr /><br />
FROM dbo_tblStatistikTmp_sb_Ind<wbr />ex<br />
WHERE (((dbo_tblStatistikTmp_sb_<wbr />Index.Tech<wbr />nik_Anzahl<wbr />)&gt;50))<br />
ORDER BY dbo_tblStatistikTmp_sb_Ind<wbr />ex.IQ;<br />
&nbsp;UNION <br />
SELECT TOP 10 dbo_tblStatistikTmp_sb_Ind<wbr />ex.IQ, dbo_tblStatistikTmp_sb_Ind<wbr />ex.Index, dbo_tblStatistikTmp_sb_Ind<wbr />ex.Anzeige<wbr /><br />
FROM dbo_tblStatistikTmp_sb_Ind<wbr />ex<br />
WHERE (((dbo_tblStatistikTmp_sb_<wbr />Index.Tech<wbr />nik_Anzahl<wbr />)&gt;50))<br />
ORDER BY dbo_tblStatistikTmp_sb_Ind<wbr />ex.IQ DESC;<br />
<br />
which gives me back the wrong results. Each query alone brings back the correct results, but in the UNION it doesn't work. Any idea why?<br />
thx<br />
Kongta
</div>
</div>


I would like to show the Top10 & Last 5 of a table in one query. I tried

SELECT TOP 5 dbo_tblStatistikTmp_sb_Index.IQ, dbo_tblStatistikTmp_sb_Index.Index, dbo_tblStatistikTmp_sb_Index.Anzeige
FROM dbo_tblStatistikTmp_sb_Index
WHERE (((dbo_tblStatistikTmp_sb_Index.Technik_Anzahl)>50))
ORDER BY dbo_tblStatistikTmp_sb_Index.IQ;
 UNION 
SELECT TOP 10 dbo_tblStatistikTmp_sb_Index.IQ, dbo_tblStatistikTmp_sb_Index.Index, dbo_tblStatistikTmp_sb_Index.Anzeige
FROM dbo_tblStatistikTmp_sb_Index
WHERE (((dbo_tblStatistikTmp_sb_Index.Technik_Anzahl)>50))
ORDER BY dbo_tblStatistikTmp_sb_Index.IQ DESC;

which gives me back the wrong results. Each query alone brings back the correct results, but in the UNION it doesn't work. Any idea why?
thx
Kongta

Top 10 &amp; Last 5

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.

Top 10 &amp; Last 5

Top 10 & Last 5