VbzCart/queries/qryRpt Pkg Trx
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
<mysql>SELECT t.ID_Order, tt.Code, t.WhenDone, iif(t.ID_Package IS NULL,"","pkg #"&p.Seq&": ")&t.Descr AS Descr, t.Amount FROM (ord_trxact AS t LEFT JOIN ord_trx_type AS tt ON t.ID_Type=tt.ID) LEFT JOIN ord_pkgs AS p ON t.ID_Package=p.ID WHERE WhenVoid IS NULL ORDER BY WhenDone, Amount>0; </mysql>
