Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
Hi all I'm trying to create a query that lists a group of records only when the last record of the group doesn't have a specific field value (trans<>'delete') (I showed the list here grouped by access, ordered by access, date)
In my other sql attempts, I'm only able to get the Delete row. SQL for Paradox tables seems to make this a difficult task. Any help is appreciated. Thank you
Thanks for the quick response Hans. Yes, Paradox is -old- and I have requested this database go to SQL Server long ago, but politics is slow... That query in SQLite does work, but, unfortunately, Paradox sql can't do that
The issue is the sub-query (at least). Paradox sql does sub-queries but doesn't treat the sub-query as a group the way SQLite does in that construction. The sub-query results are just individual records, so removing a "Delete" transaction is just 1 record
NAPS2 - Not Another PDF Scanner 2 Wonderful simple and reliable scanner application for Windows users. This still depends on your Windows having the proper scanner drivers installed, but it makes scanning to images or PDFs a lot easier.
VueScan Ultimate scanning tool for Windows, Linux, and macOS, supporting pretty much any scanner, even those no longer supported by your OS. (no scanner drivers needed!)
Frizting Free tool to design schematics and PCB's - they even offer a very affordable PCB production service.
0xED - Hex Editor Compact, fast and very flexible Hex (hexadecimal) editor for MacOS.
SpeedTest.net Test the speed of your Internet connection (requires Flash!!!)
AlternativeTo Great resource when you're looking for alternatives for an application that you'd like to use, but might not be available on your platform or the application you have is just not doing it right.
Links Page These and more of our favorite links can be found on the Links Page.
New Downloads
RenameMyTVSeries-2.3.3-GTK-Linux-x64-static-ffmpeg.tar.xzDate: 2025-07-15 - Size: 78.3 MBRename My TV Series, for Linux (64 bit GTK), a tool to assist in renaming TV Show episode files. This bundle comes with (large) static builds of ffmpeg and ffprobe.
RenameMyTVSeries-2.3.3-QT5-Linux-x64-static-ffmpeg.tar.xzDate: 2025-07-15 - Size: 78.3 MBRename My TV Series, for Linux (64 bit QT5), a tool to assist in renaming TV Show episode files. This bundle comews with rather large static builds of ffmpeg and ffprobe.
RenameMyTVSeries-2.3.3-GTK-Linux-x64-shared-ffmpeg.tar.xzDate: 2025-07-15 - Size: 1.9 MBRename My TV Series, for Linux (64 bit GTK), a tool to assist in renaming TV Show episode files. This bundle relies on ffmpeg and ffprobe shared libraries on your system.
RenameMyTVSeries-2.3.3-QT5-Linux-x64-shared-ffmpeg.tar.xzDate: 2025-07-15 - Size: 1.9 MBRename My TV Series, for Linux (64 bit QT5), a tool to assist in renaming TV Show episode files. This bundle relies on ffmpeg and ffprobe shared libraries on your system.
RenameMyTVSeries-2.3.3-Windows-x64-setup.exeDate: 2025-07-15 - Size: 48.8 MBRename My TV Series, for Windows (Intel 64 bit), a tool to assist in renaming TV Show episode files. Static builds of ffmpeg and ffprobe are included.
RenameMyTVSeries-2.3.3-macOS-Universal.dmgDate: 2025-07-15 - Size: 98.6 MBRename My TV Series, for macOS (Universal binary for Apple Silicon ARM and Intel 64 bit), a tool to assist in renaming TV Show episode files. Static universal binary builds of ffmpeg and ffprobe are included.
Downloads Page Find these and more Downloads on the Downloads Page, where you will also find articles references, operating system requirements and categories.
Amazon Ads
Support us by doing your shopping at Amazon.com, either click the link, or click one of the links below …
You can also sponsor us through these Amazon offerings:
Please consider disabling your ad blocker for our website.We rely on these ads to be able to run our website.You can of course support us in other ways (see Support Us on the left).