Deleting Duplications but keeping Original data

[puppy26]

Hi all,
I would like to execute a code to remove the duplications in the MS Access Query but keeping one one data of the duplications.

For example, in the below data, I want to check for the data in the column Part No. The part number 123 and 234 are repeated twice so I want to delete the part no 123 and 234 that repeated second time and keeping the one data.

Please do help me. I'm complete new to MS Access.

Many thanks!

Part No	Carline	Data	Call
123	BMW	1	1
123	Astra	2	2
234	Opel	3	4
235	Volks	4	6
234	Santro	5	8

[pradeep.sands]

Hi,
In the design view,use "DISTINCT" for the Part_No column.

DISTINCT(Part_No)

This should work

[puppy26]

Hi Pradeep,
Should I add Distinct(part_no) in the criteria option??

[pradeep.sands]

Hi,
I hope you have your table ready. Then create a new QUERY...
CREATE --> QUERY DESIGN
Then in the "show table" box, ADD your table.
Then go to DESIGN--> VIEW --> SQL VIEW
and there you can write your SQL code and don't forget to add DISTINCT to your PART_No field.

[puppy26]

Hi Pradeep,
If I use Distinct funtion, I'm getting error as Undefined funtion Distinct.. What should I do now!!

Many thanks for your kind help.

[puppy26]

Hi,
Well, I tried as you mentioned but still getting duplications

SELECT DISTINCT Catelogue.[Part No], Catelogue.Carline --> still getting duplications.

[pradeep.sands]

SELECT DISTINCT ([tablename].[part_no])

is this the way u mentioned?
and Distinct is not a criteria !!!
and in your table i see a space between part and no
try to remove the space and make somethng like "part_no"

[pradeep.sands]

I guess the Carline, Data and Call have different values for the same 'Part No'.
So thats the reason it still shows.
Bcoz the other three colums have different values, access doesn't consider them as duplicates even though part No alone is same.