K
Kevin C.
Hi-
I have a database where I track records and import a file
everday to update the records that were completed the
prior day. The problem I am having is that there might
be duplicate records in the table, andwhen I run my
update query to update the close dates, all instances of
the duplicate record are getting updated, even though
only 1 records should get updated. All of the
information is identical in the duplicate records except
for the ID (autonumber) field. The problem is that this
field is unknown when updating the close dates.
Is there any way to have the update query take into
account the ID# so that only 1 records will get updated
instead of all of the duplicate records?
I have a database where I track records and import a file
everday to update the records that were completed the
prior day. The problem I am having is that there might
be duplicate records in the table, andwhen I run my
update query to update the close dates, all instances of
the duplicate record are getting updated, even though
only 1 records should get updated. All of the
information is identical in the duplicate records except
for the ID (autonumber) field. The problem is that this
field is unknown when updating the close dates.
Is there any way to have the update query take into
account the ID# so that only 1 records will get updated
instead of all of the duplicate records?