Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Other Forums
 MS Access
 Flagging duplicate data
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 11/20/2013 :  18:34:04  Show Profile  Reply with Quote
I have an access database which handles GPS data from wildlife collars. The table has about 33 fields: about 25 of them are from imported datasets and the remaining fields are used for metadata and quality control such as flagging erroneous data or duplicate data.

I have been trying to write either VBA code or SQL to go through the dataset and flag duplicate records where the 25 fields are identical. Of course I want to leave one original record as unflagged.

Table Name: CollarData

Fields to test for duplicates: Collar_ID, AcquisitionTime, AcquisitionStartTime, GPSLatitude, GPSLongitude, PTT, Mortality, LowVoltage.....

Fields to Flag when duplicates Found: QAQC, QAQC_Reason

I have a decent understanding of VBA, however I do struggle with SQL syntax in access sometimes. I have been searching high and low for a solution for this but all the examples I have found only test one or two fields and I haven't be successful in expanding this to the more complicated table. Any help would be greatly appreciated.

Thanks in advance...

  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000