Sorry for the errant code. Thanks again for your assistance.

CREATE TABLE Pt_table

(encounter_id varchar(255),medical_record_num varchar(255),admit_date datetime,discharge_date datetime);

INSERT INTO Pt_table (encounter_id,medical_record_num,admit_date,discharge_date)

VALUES ('10001','7890123','01/05/2013','01/10/2013'

'10002','8901234','05/20/2013','05/23/2013'

'10003','8901234','06/20/2013','06/21/2013'

'10004','7890123','02/20/2013','02/23/2013'

'10005','7890123','02/25/2013','02/27/2013'

'10006','5678901','12/24/2013','12/24/2013'

'10007','5678901','12/24/2013','01/02/2014'

'10008','4567890','05/20/2013','06/01/2013'

'10009','4567890','07/02/2013','07/02/2013'

'10010','7890123','02/09/2013','02/18/2013');

Thanks

pt_table

encounter_id medical_record_num admit_date discharge_date {.....}

10001 7890123 ...

I have Access and Oracle users that require a table build.

Thanks for any assistance.