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
WhyNoPadLock Test your website and discover why the green padlock is not appearing when using HTTPS
Security Awareness Tip of the Day Great resource to make you online-life more secure - definitely some great tips here and a recommended read.
Kubuntu Kubuntu is a Ubuntu variant that use KDE as it's desktop manager. Fast and well supported.
Osceola, WI My other home-town ... love living there! Osceola rocks!
PhotoStream2Folder Handy little program that automatically downloads pictures and videos from iCloud - highly recommended
NCH Software - WavePad Awesome Audio editor (from audio and even video files!), free for home use, available for Windows, MacOS X, iOS and Android.
Links Page These and more of our favorite links can be found on the Links Page.
New Downloads
RenameMyTVSeries-2.3.1-Windows-x64-setup.exeDate: 2025-07-07 - 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.0-macOS-Universal.dmgDate: 2025-07-06 - Size: 98 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.
RenameMyTVSeries-2.3.0-QT5-Linux-x64-static-ffmpeg.tar.xzDate: 2025-07-06 - 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.0-QT5-Linux-x64-shared-ffmpeg.tar.xzDate: 2025-07-06 - 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.0-GTK-Linux-x64-static-ffmpeg.tar.xzDate: 2025-07-06 - 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.0-GTK-Linux-x64-shared-ffmpeg.tar.xzDate: 2025-07-06 - 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.
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).