M
Melynda E.
I understand that a strong where clause in an append query can eliminate
duplicate records. I can't seem to find a clause that will work. I've tried
tblMessage.ID not in tblChart Pull-Request.Message ID. Below is the current
SQL without my failed clause.
INSERT INTO [Chart Pull - Requests] ( [Message ID], [Date], [Time],
Requestor, Physician, [Physician Team], [Patient Name], [Patient DOB],
[Patient MRN], Reason, [Chart Pull Complete], [Chart Pull Completion
Date/Time], [Chart Not Found], [MR Notes] )
SELECT Messages.ID, Messages.Date, Messages.Time, Messages.[Staff Name],
Messages.Physician, Messages.[Physician Team], Messages.[Patient Name],
Messages.[Patient DOB], Messages.[Patient MRN], Messages.[Call Subject],
Messages.[Chart Pull Complete], Messages.[Chart Pull Completion Date/Time],
Messages.[Chart Not Found], Messages.[MR Notes]
FROM Messages;
duplicate records. I can't seem to find a clause that will work. I've tried
tblMessage.ID not in tblChart Pull-Request.Message ID. Below is the current
SQL without my failed clause.
INSERT INTO [Chart Pull - Requests] ( [Message ID], [Date], [Time],
Requestor, Physician, [Physician Team], [Patient Name], [Patient DOB],
[Patient MRN], Reason, [Chart Pull Complete], [Chart Pull Completion
Date/Time], [Chart Not Found], [MR Notes] )
SELECT Messages.ID, Messages.Date, Messages.Time, Messages.[Staff Name],
Messages.Physician, Messages.[Physician Team], Messages.[Patient Name],
Messages.[Patient DOB], Messages.[Patient MRN], Messages.[Call Subject],
Messages.[Chart Pull Complete], Messages.[Chart Pull Completion Date/Time],
Messages.[Chart Not Found], Messages.[MR Notes]
FROM Messages;