FileSent Is Table / Database Name
SELECT FileSent.[Patient#], FileSent.PatientName, FileSent.EpisodeKey, FileSent.DoctorName, FileSent.Mark, FileSent.FinancialType
FROM FileSent
WHERE (((FileSent.Mark)="1"));
DoCmd.TransferSpreadsheet acExport, 5, tablename:="FileSent"...