<div>
Try this:<br />
<br />

<pre><code id="code-20-42516529-1">SELECT 
    qryArisGet.ID, qryArisGet.POS_NR, qryArisGet.Aris, qryShapeGet.Shape
FROM 
    qryArisGet, qryShapeGet
GROUP BY 
    qryArisGet.ID, qryShapeGet.ID, qryArisGet.POS_NR, qryShapeGet.POS_NR, qryArisGet.Aris
HAVING 
    qryArisGet.ID=12203737 And qryArisGet.ID=qryShapeGet.ID And qryArisGet.POS_NR=qryShapeGet.POS_NR</code></pre>
</div>


Try this:



SELECT 
    qryArisGet.ID, qryArisGet.POS_NR, qryArisGet.Aris, qryShapeGet.Shape
FROM 
    qryArisGet, qryShapeGet
GROUP BY 
    qryArisGet.ID, qryShapeGet.ID, qryArisGet.POS_NR, qryShapeGet.POS_NR, qryArisGet.Aris
HAVING 
    qryArisGet.ID=12203737 And qryArisGet.ID=qryShapeGet.ID And qryArisGet.POS_NR=qryShapeGet.POS_NR

<div>
Thanks, I get this error though:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/03_w13/1292683/Capture3.JPG" target="_blank" title="error (21 KB)"><img alt="error" class="file-block lazyload" style="max-width: 652px;" data-src="https://filedb.experts-exchange.com/incoming/2018/03_w13/1292683/Capture3.JPG" /></a>
</div>


Thanks, I get this error though:

errorhttps://filedb.experts-exchange.com/incoming/2018/03_w13/1292683/Capture3.JPG

Capture3.JPG

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm having trouble with this query. &nbsp;Here's the code and output as it is now:<br />
<br />
SELECT qryArisGet.ID, qryArisGet.POS_NR, qryArisGet.Aris,&quot;&quot; as Shape<br />
FROM qryArisGet<br />
WHERE (((qryArisGet.ID)=12203737<wbr />))<br />
<br />
UNION all<br />
SELECT qryShapeGet.ID, qryShapeGet.POS_NR, &quot;&quot;&nbsp;as Aris,qryShapeGet.Shape<br />
FROM qryShapeGet<br />
WHERE (((qryShapeGet.ID)=1220373<wbr />7))<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/03_w13/1292642/Capture.JPG" target="_blank" title="access (16 KB)"><img alt="access" class="file-block lazyload" style="max-width: 415px;" data-src="https://filedb.experts-exchange.com/incoming/2018/03_w13/1292642/Capture.JPG" /></a><br />
What I need it to do though is group on ID and POS_NR. &nbsp;I believe you would do a Max on Aris and Shape to give you this but I can't get the syntax right. &nbsp;This is the result that I need:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/03_w13/1292643/Capture2.JPG" target="_blank" title="excel (15 KB)"><img alt="excel" class="file-block lazyload" style="max-width: 422px;" data-src="https://filedb.experts-exchange.com/incoming/2018/03_w13/1292643/Capture2.JPG" /></a><br />
Thanks for your help,<br />
Joel
</div>
</div>


Capture2.JPG

Capture.JPG

Hello,

I'm having trouble with this query.  Here's the code and output as it is now:

SELECT qryArisGet.ID, qryArisGet.POS_NR, qryArisGet.Aris,"" as Shape
FROM qryArisGet
WHERE (((qryArisGet.ID)=12203737))

UNION all
SELECT qryShapeGet.ID, qryShapeGet.POS_NR, "" as Aris,qryShapeGet.Shape
FROM qryShapeGet
WHERE (((qryShapeGet.ID)=12203737))



What I need it to do though is group on ID and POS_NR.  I believe you would do a Max on Aris and Shape to give you this but I can't get the syntax right.  This is the result that I need:



Thanks for your help,
Joel

MS Access query

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.