Recent content by rosef

I thought the StrComp function compares to fields. I just want to compare on field with case sensitivity.

When I do a duplicate query in Access using the ID field it is showing the ones below as duplicates and I don't want them to be shown as duplicates. 0013h00000HFbsa and 0013h00000HFbsA The "A" on the end one is upper case and one is lower case. They should not be duplicates. I have a lot of...

I am trying to discover the duplicate entries.

I have a table that has a ID field that is case sensitive. I am trying to run a duplicate query on the ID field but it is not taking in account upper and lower case? Is there a way in a simple query to check for duplicates based on upper and lower case?

Thanks so much. This is just what I needed.

@MajP Thank you so much. It was just wanted I needed.

I am doing some data clean-up on a birthdate field. I have over 5000 records that need the 20XX changed to 19XX of the date field. Is there away that I can update just the 20 to 19? If so, how?

I have a Date/Time field (1 Eye Exam Date) in an Access table but I need to update at Start time field with 1 Eye Exam Date plus 12:00:00 PM. I have tried updating the Start Time with 1 Eye Exam Date+" "+ 12:00:00 PM but I received a validation error. I have tried creating a time field with...

I have worked with Access a lot in the past but just for data manipulation. I am not a programmer. I live in California, USA. I enjoy walking, spending time with family and watching movies.