SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

Subarcticguy
Starting Member

Canada
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  
 New 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.05 seconds. Powered By: Snitz Forums 2000