by Jonathan Halder | Jun 30, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
Just now I was thinking it sure would be nice if CoPilot could analyze my Access database and give me tips on things. So I tried an experiment. I asked CoPilot if it could create databases or if I could upload my database for it to analyze. It thought it would be able...
by Jonathan Halder | Jun 26, 2025 | Blogging, MS Access, MS Access Queries
I had never heard of a cross join, but was exploring ways to put some complex calculations into other calculations in a nested fashion on SQL server. SQL does not allow you to reference a calculated column to calculate another column, but this method allows you to add...
by Jonathan Halder | Jun 26, 2025 | Blogging, MS Access, MS Access Queries
This was the technique I ended up using in my query which inspired this article. Again, I had help from Copilot to author the following article about using the CTE (Common Table Expression) syntax: When writing SQL queries, especially those involving multiple layers...
by Jonathan Halder | Jun 20, 2025 | Blogging, MS Access, MS Access Queries, MS Access Reports, MS Access VBA Coding
I was asked by a customer to mark fields in red that changed each week in a report. So what strategy did I come up with? Well first I need to store the data from the original run of the report. The customer wants to know what changed since the last automated report...
by Jonathan Halder | Jun 19, 2025 | Blogging, MS Access
If you’re a Star Wars fan you might remember one of the Y-wing pilots flying through the Death Star trench, flying towards the tiny little vent he needs to shoot his torpedo into in order to take advantage of a tiny flaw that would mean the destruction of the...
