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

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

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

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

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

(After these queries are run using SQLExec32 then run Start->All Programs->Software Motif->Audit Balances with audit statement balance checked.)