Search results

  1. R

    Duplicate Query - Case Sensitive

    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?
  2. R

    Solved How to update the century in a date field?

    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?
  3. R

    Solved Update a Date/Time Field - Date is already a field but I need to add time as 12:00:00 PM

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

    Hello

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