Recent content by sibemol

It worked!!!!! It took me a while to figure it out, however, by following each of the steps, it worked!!! It deleted 5343 rows with repetitious MRNs. Thanks a lot!

I have a table (imported from an Excel sheet) with 9,500 Rows. I have the following Fields: MRN, Person Name, Birth Date, Gender, Ethnic Group. As I reviewed this table I realized each row is being repeated 8-10 times. e.g.: 11111, Juan Moreno, 1/1/2010, Male, Hispanic 11111, Juan Moreno...

"Second, make a select query that shows all the records to delete including the one to leave." How do you do that without having to read 10,000 rows? I do not know how to command acces to delete all repeated records without me having to choose each one individually. Do you think a SELECT...

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...

I'm sure those are really great ideas. However, I have no clue what an update query is, much less how to run it. As I progress in my learning curve they will make more sense. Nevertheless, your message triggered something on the left side of my brain that may help others with a similar...

Do you know of an easier way of deleting the "CDT" rather than deleting it 3500 times in each record? Thanks.

When I imported, the only way I was able to import was as "Text" instead of "Date/time". Everytime I attempted to import as "Date/time" , the records would get deleted. I also attempted to change the cell format in excel to "Date" instead of "General", this did not solve the problem either...

All I have is an Excel File with all the records. I imported to access because I will be expanding upon the database in the future.

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...

You can try by using the Mean Arterial Pressure (MAP) which is calculated based on Sistolic and Diastolic... This would give you the "one" value you are looking for and then you could calculate the percentage increase. MAP= [(2 x DP) + SP] / 3 Where DP= Diastolic Pressure, SP= Sistolic...