Append Query - one field distinct

[Rhubie]

I have a child table - that I want to pull all of the distinct MasterKey field data, but the PrintableDescription field is not unique - is there a way to do this? I am new to the append query.

INSERT INTO [Master Key] ( MasterKey, PrintableDescription )
SELECT [Master Children].MasterKey, [Master Children].PrintableDescription


FROM [Master Children];

[JoeM]

Are you saying that the SELECT part of your query returns duplicate records and you want to get rid of the duplicates and just return unique records?
If so, just add the word "DISTINCT" after "SELECT", i.e.

INSERT INTO [Master Key] ( MasterKey, PrintableDescription )
SELECT DISTINCT [Master Children].MasterKey, [Master Children].PrintableDescription
FROM [Master Children];