Reply to thread

Message

<blockquote data-quote="HB13DISH" data-source="post: 540533" data-attributes="member: 262829">I need help from a SQL guru to define SQL statements that I need for my project.Going back to the example given in the above post, I have attached Access mdb file in order to explain where I am stuck and also two pdf files, the first one as a result of the working SQL query and the second the results that I hope to achieve hopefully with the refined SQL statement.This SQL statement will give me the results as shown in query1.pdfSELECT SatParts.Distributor, SatParts.SatPart, SatParts.MakeFROM SatPartsORDER BY SatParts.Distributor;What I need is to refine the SQL statement so that I will only get the distributor Maplin shown once, that is delete the word Maplin from the following rows, as shown in query2.pdfThanks for any suggestions. <img src="https://www.satellites.co.uk/styles/default/xenforo/smilies/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="HB13DISH, post: 540533, member: 262829"] I need help from a SQL guru to define SQL statements that I need for my project. Going back to the example given in the above post, I have attached Access mdb file in order to explain where I am stuck and also two pdf files, the first one as a result of the working SQL query and the second the results that I hope to achieve hopefully with the refined SQL statement. This SQL statement will give me the results as shown in query1.pdf [COLOR=Blue]SELECT SatParts.Distributor, SatParts.SatPart, SatParts.Make FROM SatParts ORDER BY SatParts.Distributor;[/COLOR] What I need is to refine the SQL statement so that I will only get the distributor Maplin shown once, that is delete the word Maplin from the following rows, as shown in query2.pdf Thanks for any suggestions. :) [/QUOTE]

Verification