Hey everyone! Just wanted to provide an update as I was able to correct the issue relatively painlessly.
Firstly, I should explain how the DB is set up, and also specify that I did not build it but I am in charge of maintaining it. There is a "back end" .accdb which contains all of the tables...
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...
Yes, that would be ideal but unfortunately this is data coming from a third party. :/ I'm going to try CJ_London's suggestions and see how it turns out.
Hey jdraw,
They are ratings. I guess a better example would be the student scores in different subjects, and I want to find which subject each student excels at the most. Ex: Student A got a 55.4% in Math and a 78.2% in Science. So I'd highlight Science as Student A's top class.
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...
Yikes! That's all I'm going to say about what this thread became. At least I had some early morning entertainment to wake me up!
I ended up using MajP's original post, solely because it resonated with me the most and I knew how to implement it. As someone who only uses Access on occasion, it...
Hello MajP,
Thanks for replying! Are you asking about what I wrote here?
What I mean is that I will have to group records based on the "State" field, and then compare the first record's "End Mile" to the next record's "Start Mile", like so:
If the End Mile and Start Mile do not match...
Hello!
Sorry it has taken a month to get back to you. I got sidetracked with other projects that popped up, as well as a health emergency in the family.
I tried your queries, but as far as I remember, they did not work. The database kept crashing without any errors. I ended up completely...
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...
It happens on the first pass. I was wondering if it was a reference issue (they seem to happen quite often), and I checked earlier, but nothing was missing. It is currently using version 2.8.
I will be honest: I'm not sure what ADODB & DAO are exactly. Is there a way I can clean up the code...
I checked and Option Explicit is declared for each module. I clicked Compile and I believe it worked? I've never compiled in Access before. Everything froze for a few seconds and then went back to normal. The Compile option is now greyed out.