MS Access Help Urgently needed

[rexie]

Hi all,
I am needing some urgent help in MS access. I have a query with three fields and what I need to find is to give me all the records with duplicate values, (FieldA + FieldB + FieldC)is kinda key. I have tried using duplicate query but no luck,

Please help!!!

 

[930driver]

Open a query in design mode and switch to SQL view. Paste the following in:

SELECT Field1, Field2, Field3, Count(Field1) AS CountOfDuplicates
FROM tblTableName
GROUP BY Field1, Field2, Field3
HAVING (((Count(Field1))>1));

Change the field names as appropriate and change tblTableName to the name of the table from which the fields come.

This should give you a list of records that have duplicates and tell you how many duplicates there are.
"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[rexie]

hi,

Thanks for the reply, but the query seems to be choking, its not working.

I have 3 fields Customer_id, Invoice_ID, Apply_ID, I want to pick the Same Customer_id, same Invoice_ID, same Apply_ID, meaning to say, the combination of the fields should be a key and find those duplicates. Please help

 

[930driver]

In the SQL statement did you replace EVERY occurence of Field1 with Customer_ID etc. and enter the correct table name?

What message do you get when it chokes? "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[rexie]

Hi,

I greatyl appreciate your time and effort, my whole project was wrong and that is why your duplicate query wasnot working, I once agin thank you a lot for your help. I am facing yet another problem with the same project. I would like to use a "Select Case " Statement in my build. What I wanna do is to have multiple IF statements. Can your suggest something.

thanks once agian

 

[930driver]

rexie,

Please repost your question in a new thread so that people interested in this new subject will see it.
"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"