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)
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
Ad Blocking Detected
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).
NCH Software - WavePad Awesome Audio editor (from audio and even video files!), free for home use, available for Windows, MacOS X, iOS and Android.
Start-is-Back Ultimate Start-button replacement for Windows 8 and 8.1 - Super cheap, but highly recommended.
Frizting Free tool to design schematics and PCB's - they even offer a very affordable PCB production service.
MySolutions.Tech Best DVD/Blu-ray/Video Solutions-Help You to Digitize Your Colorful Life
Media Player Classic My favorite media player for Windows - light weight and supports all common video formats.
Microsoft Virtualization Tools Free and totally legal Windows virtual machines for testing Internet Explorer and applications (Windows XP, Vista, 7, 8, 8.1 etc)! Works great for running Windows on a Mac or Linux machine!
Links Page These and more of our favorite links can be found on the Links Page.