I use ASPDB EP. How can I use dbAggSQL and dbAggMagic cell methods in combination with MyDb.dbFilterDropFlds. I found out that the total is not always correct after applying filter. My filter comes from different tables.
Thanks in advance for your help.


Here is the code.

MyDb.dbAggSQL="SELECT sum(weight), sum(piece) FROM airwaybill"
MyDb.dbAggMagicCell="0,bgcolor=yellow; 1,bgcolor=yellow"
MyDb.dbAggNameTag="ColSPAN=5 align=right size=2"


FILT = "CustomerID,,,,select customerid from customers where station = 'SFO' ;" & "PODStation,, [Station],StationCode;" &_
"PODStatus,, [Status],Status;" &_
"ServiceType,, [Airwaybill],ServiceType,,,,,Distinct;" &_
"FlightNo,,,,Select Distinct FlightNo from Airwaybill Where OriginStation = 'SFO';"

MyDb.dbFilterDropFlds = FILT