Help Filtering duplicate records from query

[Barrelwaves]

Dear Experts,
I have created a database with queries that is working fine, however there are many records that have the same information that can not be removed easily, is there a method anyone knows of that can filter the records produced from a query to remove duplicates? i.e. 'select distinct' but for the whole query after the search parameters have been entered.

e.g. the search query is producing, after the refined search values are entered:
414353p - Fiat - 1.6 - MLS
414353p - Fiat - 1.6 - MLS
How can i then apply a filter to automatically reduce these duplicates to just one entry for the whole form?

Thanks

 

[rsmonkey]

See the attachment it gives you a vba soloution to your problem.. check out the code, queries etc!

 

[Barrelwaves]

Thanks for that, unfortunately it has gone right over my head!! can i simply add this code to my database in the vb code for the form produced from the query?
Or is there another way of doing this?
Sorry im not very clued up with applying the vb code solution.

 

[Barrelwaves]

Not to worry everyone found an easy way, simply set 'unique records' in the query properties to 'yes'!

 

[MKavita]

How to Delete Duplicate Record

How to Delete Duplicate Record ?
or what is the query for duplicate record for make table query.

Sample date
my question is to make table of duplicate NO field.?

NO SALUTATION S_NAME FIRST_NAME LAST_NAME
12 Mr SURESH R SURESH R
12 Mr. SNAGABVSHAN S SNAGABVSHAN S
45 Mr MAHESH N MAHESH N
12 Mr IVANDSOOZA B IVANDSOOZA B
12 Mr. KALEEMULLAKHAN EKALEEMULLAKHAN E
33 Mr NEMACHANRA S NEMACHANRA S
5 Mr MANJU B MANJU B
6 Mrs GANGALAKSHMMA CGANGALAKSHMMA C
6 Mr EASANOORUSHEED SEASANOORUSHEED S
6 Mr. NAGESH B NAGESH B
77 Mr. NARAYANA N NARAYANA N
5 Mr. KESHAV K KESHAV K
help me out

 

[neileg]

Have you tried the 'Find Duplicates' wizard?

 

[Mike375]

MKavita

If you do as Neil suggested then your example will look like below

.....Just go to Queries, then New and then Find Duplicates Query Wizard. It is straight forward from there

12 Mr SURESH R SURESH R
12 Mr. SNAGABVSHAN S SNAGABVSHAN S
12 Mr IVANDSOOZA B IVANDSOOZA B
12 Mr. KALEEMULLAKHAN EKALEEMULLAKHAN E
5 Mr MANJU B MANJU B
5 Mr. KESHAV K KESHAV K
6 Mrs GANGALAKSHMMA CGANGALAKSHMMA C
6 Mr EASANOORUSHEED SEASANOORUSHEED S
6 Mr. NAGESH B NAGESH B