G
Guest
I am importing data from one table to another. There is a potential for
duplicates that I am trying to eliminate using a delete query. The
tblAppointments has the following fields an appointmentID (autonumber and
keyfield), clientID(not unique), and AppointmentDate.
tblUpdateAppointments is used to update tblAppointments using an append
query. But before I want the append query to run, I would like to remove
records that have the same clientID AND AppointmentDATE because these are
duplicates. I have written the following delete query but it will not run and
I'm not sure why. Any help would be much appreciated.
DELETE tblUpdateAppointments.*, tblUpdateAppointments.[clientID],
tblUpdateAppointments.[AppointmentDate]
FROM tblUpdateAppointments, tblAppointments
WHERE (((tblUpdateAppointments.[clientID])=[tblAppointments].[clientID]) AND
((tblUpdateAppointments.[AppointmentDate])=[tblAppointments].[AppointmentDate]));
duplicates that I am trying to eliminate using a delete query. The
tblAppointments has the following fields an appointmentID (autonumber and
keyfield), clientID(not unique), and AppointmentDate.
tblUpdateAppointments is used to update tblAppointments using an append
query. But before I want the append query to run, I would like to remove
records that have the same clientID AND AppointmentDATE because these are
duplicates. I have written the following delete query but it will not run and
I'm not sure why. Any help would be much appreciated.
DELETE tblUpdateAppointments.*, tblUpdateAppointments.[clientID],
tblUpdateAppointments.[AppointmentDate]
FROM tblUpdateAppointments, tblAppointments
WHERE (((tblUpdateAppointments.[clientID])=[tblAppointments].[clientID]) AND
((tblUpdateAppointments.[AppointmentDate])=[tblAppointments].[AppointmentDate]));