Recent content by DimWit

Progress: we're down to "wa." 😁 No, seriously, when I process long enough the mist clears. It's not you, I just have to exercise the frontal cortex in ways long-atrophied. Metaphorically, I'm an old man with a walker in lane 8 of the Olympics Men's 100 Meter event. Your example very nicely...

There's so much good stuff going on in this thread but I stop for a trivial issue. I tried to include the entire link to Doc_Man's 6-year-old post at the top of this thread and when I went to post, I got a message saying it looked like spam. I was able to proceed by removing https : / /...

You make my head hurt--but in a very good way. Old dogs, etc. Thanks much Ken.

Thanks for the insights. My initial port to Access was from an .xlsx file--I initially tried to work in Excel but ran into inconsistent results using vlookup. Coding background: Back in the last millennium I started with VB3 and stepped away from VB6 when it appeared that VB.NET was C#-based and...

Thanks Ken!

In deference to your advanced age (;)) I wanted to make it easy and tried include the full link but when I went to post, it barked about spam. [I hope in 2 years I have a fraction of your memory and recall.] The (up-to-date, complete) export at the end of November was 2.8K rows. But the request...

I'd prefer it be cumulative. Data retrieval was demonstrated to me and the person responsible for retrieving information (a 3rd year law student [lawyer jokes aside, is both intelligent and smart]) had so thoroughly bollixed up the four date selection criteria that it took minutes to gentle...

Thanks plog I started in Excel using vlookup and got inconsistent results appending levels. Plus Excel (what's the technical term? oh, yes) 'sucks' at reports. And, sigh, I understand Access better than Excel [that is a relative comparison]. My goal is to deliver a user-maintainable solution...

Thanks Mark. I'll get back with a few questions if I go this way. Great point about level-creep (don't forget silver, platinum, titanium, lanthanum, cerium, praseodymium, etc. 😁)

(Posted here b/c the referenced post was here--feel free to suggest a different forum) In the planning stage of a database. Background A non-profit wants track member progression through training courses hosted by a third-party Learning Management System. The NP has arbitrarily split courses...

Thanks Doc, I think I'm a wit but my wife often gently reminds me I'm only half right. Dimly so.

Thanks for the orientation/mentorship Doc_Man. Props where due. Thanks all!

This forum is awesome for the collateral information gained. Thanks @DHookom

SUCCESS!!! Thanks, Dave for seeing what I'd missed. Thanks MajP for your correct diagnosis. Thanks ALL for your informed analysis. Where the Null is I'm not sure, but that did the trick.

The database is not in use. I inspected the tables and there are no empty records. Some grace requested if it appears I'm getting pedantic, but I want to be sure your words were correctly received. - Checkboxes, LvlnChk, are placed in the same section as the image boxes LvlnImg - LvlnChk...