Simple Find Duplicate Query

[pickslides]

Hi all

Just want to confirm i'm on the right track with a very simple query.

I have a table with over 4 million records . It holds historic water consumption data for some 300,000 properties. The fields are as follows:

Property ID (integer)
To Date (date)
From Date (date)
KL consumption (integer)

No Master Key!

I want to find if out of the 4 million records if any of the entire record is a duplicate with another. I do the data pretty well. I know if Property ID and To Date are the same when finding duplicates then this is enough information to determine that the record is a duplicate.

So I have gone to the wizard picked Property ID and To Date to be possible duplicates and added the remainding to view in the query.

Is this correct?

Thanks for reading...

 

[KenHigg]

The fastest thing is to try and set those fields up as a composite primary key and see if it allows - ?

 

[marianne]

if you only want to know if there are duplicates, why dont you create a query of that table and count the property id so you will know how many are of duplicates.

 

[pickslides]

The fastest thing is to try and set those fields up as a composite primary key and see if it allows - ?

Ken thanks for replying. Not to sure on how to set up a composite primary key, but will google it.

 

[pickslides]

if you only want to know if there are duplicates, why dont you create a query of that table and count the property id so you will know how many are of duplicates.

hi maryanne, was a thought I have already had but there is more than one lot of data per property. Approx 4,000,000 / 300,000 = approx 12 - 14 records per property (with that identifier).

I suppose I actually want to remove the records that are duplicates now I think about it.