DELETE CP_DP.UID
FROM CP_DP
WHERE (((CP_DP.UID)<>0));

DELETE tblFinancial.Chart
FROM tblFinancial
WHERE ((Not (tblFinancial.Chart)=""));

DELETE CP_DSD.Chart
FROM CP_DSD
WHERE ((Not (CP_DSD.Chart)=""));

DELETE tblCEFindings.Chart
FROM tblCEFindings
WHERE ((Not (tblCEFindings.Chart)=""));

DELETE CP_DSIRTF.UID
FROM CP_DSIRTF
WHERE (((CP_DSIRTF.UID)<>0));

DELETE CP_DSIRTFSubmitHistory.ID
FROM CP_DSIRTFSubmitHistory
WHERE (((CP_DSIRTFSubmitHistory.ID)<>0));

DELETE CP_DNI.ID
FROM CP_DNI
WHERE (((CP_DNI.ID)<>0));

DELETE tblAppointment.RecordID
FROM tblAppointment
WHERE (((tblAppointment.RecordID)<>0));

DELETE tblBillingCycle.ID
FROM tblBillingCycle
WHERE (((tblBillingCycle.ID)<>0));

DELETE tblCheckIn.RecordID
FROM tblCheckIn
WHERE (((tblCheckIn.RecordID)<>0));

DELETE tblClaim.Created
FROM tblClaim
WHERE ((Not (tblClaim.Created)=#1/1/1900#));

DELETE tblClaimCarrierDetail.*
FROM tblClaimCarrierDetail;

DELETE tblClaimDeleted.*
FROM tblClaimDeleted;

DELETE tblClaimSubmitHistory.Chart
FROM tblClaimSubmitHistory
WHERE ((Not (tblClaimSubmitHistory.Chart)=""));

DELETE tblDXSet.Chart
FROM tblDXSet
WHERE ((Not (tblDXSet.Chart)=""));

DELETE tblLetter.Chart
FROM tblLetter
WHERE ((Not (tblLetter.Chart)=""));

DELETE tblLog.Created
FROM tblLog
WHERE ((Not (tblLog.Created)=#1/1/1900#));

DELETE tblNote.Chart
FROM tblNote
WHERE ((Not (tblNote.Chart)=""));

DELETE tblPlan.Chart
FROM tblPlan
WHERE ((Not (tblPlan.Chart)=""));

DELETE tblPreBill.RecordID
FROM tblPreBill
WHERE (((tblPreBill.RecordID)<>0));

DELETE tblProvider.ID
FROM tblProvider
WHERE ((Not (tblProvider.ID)="*TEMP"));

DELETE tblSchedule.RecordID
FROM tblSchedule
WHERE (((tblSchedule.RecordID)<>0));

DELETE tblThirdParty.Chart
FROM tblThirdParty
WHERE ((Not (tblThirdParty.Chart)=""));

DELETE tblThirdPartyNYC4.ID
FROM tblThirdPartyNYC4
WHERE (((tblThirdPartyNYC4.ID)<>0));

DELETE tblTransaction.RecordID
FROM tblTransaction
WHERE (((tblTransaction.RecordID)<>0));

DELETE tblTransactionDeleted.RecordID
FROM tblTransactionDeleted
WHERE (((tblTransactionDeleted.RecordID)<>0));

DELETE tblUserDefinedData.Chart
FROM tblUserDefinedData
WHERE ((Not (tblUserDefinedData.Chart)=""));

DELETE tblVisitCounter.Chart
FROM tblVisitCounter
WHERE ((Not (tblVisitCounter.Chart)=""));

DELETE tblVoiceNote.ID
FROM tblVoiceNote
WHERE (((tblVoiceNote.ID)<>0));

DELETE tblXRayFilms.ID
FROM tblXRayFilms
WHERE (((tblXRayFilms.ID)<>0));

DELETE tblXRays.ID
FROM tblXRays
WHERE (((tblXRays.ID)<>0));

DELETE tblGeneral.*, tblGeneral.ID
FROM tblGeneral
WHERE (((tblGeneral.ID)="LASTPAT"));
 
DELETE tblCPVPatientInsurance.*
FROM tblCPVPatientInsurance;