If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Imported text file w/o unique identifiers, find duplicates
Imported a txt file w/o unique identifiers and have run a query to find
possible duplicate records based on 3 seperate fields. How can I either update those fields that may be in error in the original table or append a new record w/o the duplicate data and delete the original record? In the following I need to determine which records to keep, which to delete and/or which to update. End Date Total Sheets Time Operator Name 3/3/2007 14 0:00 00094123 B D MCNARA 3/3/2007 14 0:00 00095681 NAME UNKNOWN 3/17/2007 84 0:01 00091234 C D S 3/17/2007 84 0:01 00097282 J M Rob |
#2
|
|||
|
|||
Imported text file w/o unique identifiers, find duplicates
Update....I was considering having the operator hit a checkbox or something
to indicate if a record needs to be deleted, however can't figure out how to get this delete query to delete that record from the original txt file, not the query that I used to locate it? Would that work, and how? "jeremiah" wrote: Imported a txt file w/o unique identifiers and have run a query to find possible duplicate records based on 3 seperate fields. How can I either update those fields that may be in error in the original table or append a new record w/o the duplicate data and delete the original record? In the following I need to determine which records to keep, which to delete and/or which to update. End Date Total Sheets Time Operator Name 3/3/2007 14 0:00 00094123 B D MCNARA 3/3/2007 14 0:00 00095681 NAME UNKNOWN 3/17/2007 84 0:01 00091234 C D S 3/17/2007 84 0:01 00097282 J M Rob |
#3
|
|||
|
|||
Imported text file w/o unique identifiers, find duplicates
You might read these records into a temporary table that also contains a
Yes/No field. Then you create a "Find Duplicates" query that uses whichever fields you think should be unique to identify the duplicates. Then, display a continuous form based on the duplicates query and allow the user to check the yes/No field for those records that are to be deleted. Add a "Delete Checked" button in the footer of this form, and run a query that deletes the checked records and then requeries the form. Once there are no "duplicates" in the list, allow the user to append the remaining records to your main table. HTH Dale -- Don''t forget to rate the post if it was helpful! email address is invalid Please reply to newsgroup only. "jeremiah" wrote: Update....I was considering having the operator hit a checkbox or something to indicate if a record needs to be deleted, however can't figure out how to get this delete query to delete that record from the original txt file, not the query that I used to locate it? Would that work, and how? "jeremiah" wrote: Imported a txt file w/o unique identifiers and have run a query to find possible duplicate records based on 3 seperate fields. How can I either update those fields that may be in error in the original table or append a new record w/o the duplicate data and delete the original record? In the following I need to determine which records to keep, which to delete and/or which to update. End Date Total Sheets Time Operator Name 3/3/2007 14 0:00 00094123 B D MCNARA 3/3/2007 14 0:00 00095681 NAME UNKNOWN 3/17/2007 84 0:01 00091234 C D S 3/17/2007 84 0:01 00097282 J M Rob |
#4
|
|||
|
|||
Imported text file w/o unique identifiers, find duplicates
Thank you Dale, once again this community has saved me....
"Dale Fye" wrote: You might read these records into a temporary table that also contains a Yes/No field. Then you create a "Find Duplicates" query that uses whichever fields you think should be unique to identify the duplicates. Then, display a continuous form based on the duplicates query and allow the user to check the yes/No field for those records that are to be deleted. Add a "Delete Checked" button in the footer of this form, and run a query that deletes the checked records and then requeries the form. Once there are no "duplicates" in the list, allow the user to append the remaining records to your main table. HTH Dale -- Don''t forget to rate the post if it was helpful! email address is invalid Please reply to newsgroup only. "jeremiah" wrote: Update....I was considering having the operator hit a checkbox or something to indicate if a record needs to be deleted, however can't figure out how to get this delete query to delete that record from the original txt file, not the query that I used to locate it? Would that work, and how? "jeremiah" wrote: Imported a txt file w/o unique identifiers and have run a query to find possible duplicate records based on 3 seperate fields. How can I either update those fields that may be in error in the original table or append a new record w/o the duplicate data and delete the original record? In the following I need to determine which records to keep, which to delete and/or which to update. End Date Total Sheets Time Operator Name 3/3/2007 14 0:00 00094123 B D MCNARA 3/3/2007 14 0:00 00095681 NAME UNKNOWN 3/17/2007 84 0:01 00091234 C D S 3/17/2007 84 0:01 00097282 J M Rob |
Thread Tools | |
Display Modes | |
|
|