NO TOUCHY
October 30, 2021 :: 4:00 PM
reminds me of the 75 different versions of the SG budget…
І ми продовжуєм нести свій прапор, а не хрест. Ми продовжуєм іти на власний Еверест.
And we continue to carry our banner, but not our cross. We continue to walk on our own Everest.
- - - - - - - - - -
SOOOOOOO.
We are at 5 days until Wine and Dine. FIVE! DAYS!
Five days until I run a 5K, a 10K, and a half marathon around Epcot. (And some Disney parking lots… *sigh*)
Yeah.
I can’t say that I’ve trained particularly well, but it can’t be nearly as hard as a Racery event.
(Also, whoever curated the runDisney Training playlist on Spotify needs some serious help. I find none of the songs inspiring.)
A zillion years ago, I wrote about this nifty little report I was trying to write.
A quick rundown of the process:
I beat the snot out of QuickBooks until I could run two reports.
I export those reports to Excel and clean them up. QuickBooks exports the Estimates vs Actuals report like… well, it looks like it barfed data all over the place. So, there’s a lot of cleaning up of that particular report. The custom Customer report isn’t nearly as bad, but it’s not necessarily great, either.
Once that’s done, I import them into Access.
Run a couple of queries.
Load the report.
And BOOM!
A very usable, very pretty, Jobs in Progress report.
It mooshes, it squooshes, it slices, it dices!
Until you try to update the data.
And then it’s a different type of BOOM!
Yeah… I broke the fuck out of that when I went to update the data.
Part of the problem is that I couldn’t append the new information because it would create duplicates. It wouldn’t be such a bad thing, but it was hard to parse out the old data that way. So, I got the bright idea to append and then delete the old data.
And it was beautiful.
All the queries worked, but the report didn’t.
I thought it had something to do with the dataset becoming screwed up when I deleted the old data.
So I went to the backup I made. And then, because I don’t trust myself, I created a back up of THAT backup.
I named it NO TOUCHY because, well, I kept over writing the first backup.
I swear, I am smart.
Anyhoo…
I beat my head against the wall for a few weeks, playing with it here and there, when I had a spare moment at work.
Yesterday, I had the hallelujah moment.
I HAD NAMED ONE OF THE FIELDS DIFFERENTLY.
Turns out there is a big fucking difference between CustNum and Cust Number. ESPECIALLY when the damn thing is looking for CustNum.
So now, my pretty report works again.
About fucking time.
Great snippet of life at home:
Me: So, I’m watching Titans and it’s OK. You know, DC Comics, Robin.
Him: I thought you didn’t like superheros.
Me: No, I don’t, but I’m totally down for some Dick Grayson.
Him: Dick Racing?
Me: That too.