11–20 of 52 posts
In his follow up post he talks about union combining identical results. If the author ever reads this, you can prevent that by using `union all` instead of just `union`. That won't remove duplicates.
I‘ve been using MS Access some twenty years ago to do all sorts of magic for small businesses. That was from the 90s to the early 2000s. - Later I‘d use Python to do magic for companies who didn‘t know anything better than MS Excel to handle large sets of data, and when they were lost in chaos, I‘d start to streamline, process, tidy their data and help them make sense. Just two examples that showed me: Use whatever h…
Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?
I‘ve been using MS Access some twenty years ago to do all sorts of magic for small businesses. That was from the 90s to the early 2000s. - Later I‘d use Python to do magic for companies who didn‘t know anything better than MS Excel to handle large sets of data, and when they were lost in chaos, I‘d start to streamline, process, tidy their data and help them make sense. Just two examples that showed me: Use whatever h…
Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?
I‘ve been using MS Access some twenty years ago to do all sorts of magic for small businesses. That was from the 90s to the early 2000s. - Later I‘d use Python to do magic for companies who didn‘t know anything better than MS Excel to handle large sets of data, and when they were lost in chaos, I‘d start to streamline, process, tidy their data and help them make sense. Just two examples that showed me: Use whatever h…
Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?
Alternatively, you can access Google Sheets with SQL queries, although I guess it probably wouldn't be great, but Google Forms + Sheets?
Earlier quoted context omitted.
Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?
Simple CRUD apps with Python + Flask or Django I‘d say.
I‘ve been using MS Access some twenty years ago to do all sorts of magic for small businesses. That was from the 90s to the early 2000s. - Later I‘d use Python to do magic for companies who didn‘t know anything better than MS Excel to handle large sets of data, and when they were lost in chaos, I‘d start to streamline, process, tidy their data and help them make sense. Just two examples that showed me: Use whatever h…
Only vaguely related: what would be the Access equivalent of today? Somethings with low learning curve and forms. Any suggestions?