-
dbAggSQL
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|