Search results

I have a database with thousands of records for each of the following fields: Medical Record Numbers (MRN), Names, DOB, Gender, Ethnic Group. In ALL patients each row is repeated 9-10 times. I would like to delete ALL repeated records based on MRN in a way that it would allow me to have...

Hello, I am a new user of Access. I am building a database. I have 3500 "date" records in the following format: "04/21/05 01:30 CDT", the field DATA TYPE in table design is set as "TEXT". I wish to change the DATA TYPE from "TEXT" to "DATE/TIME". However, everytime I attempt this, an error...