Search results

Hello everyone! A database user was filling out a form and entered a quotation mark into one of the fields. This caused the record to become corrupted: It also removed the auto-generated primary key in the LabNum field. I've tried editing the record to remove all the data, replacing the...

Hi all! I have a table with ~200 records and I need to compare 11 different fields to find which field has the largest value. Here's an example table: State Name Value 1 Value 2 Value 3 Value 4 Value 5 Value 6 Value 7 Value 8 Value 9 California 20.22 94.2 74.0 75.9 33.33 67.4 60.5 92.1...

Hello everyone! I'm attempting to do a "Gap Analysis" where I look for gaps in our data. Here's an example table: State Start Mile End Mile California 2.6 3.5 California 3.5 4.7 California 5 6.1 Florida 0 1.4 Florida 1.6 2 For California, there is a gap between 4.7 (end mile of...

Hello! Let me start by stating that I'm pretty much a novice when it comes to Access, so please let me know if I can explain things more clearly or use different verbiage. I have an Access database that was created by someone else years ago. Its purpose was to take Access data from a piece of...