Subject Re: Filter problem From Heinz Kesting <Nobody@Nowhere.com> Date Sat, 29 Mar 2025 13:44:38 +0100 Newsgroups dbase.getting-started Hi Charlie, > Thanks Heinz and Mervyn... > > I actually figured this out after your hint, Heinz.  The 'group by' threw me off. > > sql = "SELECT category, SUM( qty * estv ) AS catval FROM COLLECTION group by category" > > I had been using xdml functions for this.  But oodml and xdml do not mix well when deleting so this fixes that problem. > You're welcome, and thanks for the feedback - it's always good to know how the issue was solved! Kind regards, Heinz -- Diese E-Mail wurde von Avast-Antivirussoftware auf Viren geprüft. www.avast.com