REPORTFORM;close4.frf
TITLE;รายงานปิดกิจการ ตามวันที่
SQL;select 
SQL;closehd.datedoc, closehd.docno, closehd.BOOKDOCNO, datecancel , closehd.aid, bookhd.saccid ,
SQL;bookhd.accid, armst.XCOMP,remarkmst.REMARK
SQL;from closehd left join bookhd on closehd.BOOKDOCNO = bookhd.DOCNO
SQL;left join armst on bookhd.ACCID = armst.ACCID
SQL;left join remarkmst on closehd.REMID = remarkmst.REMID
SQL;order by datedoc,docno
CONDITION;ตั้งแต่วันที่ ~CLOSEHD.DATEDOC~Date~2~~
EXCELSQL;select 
EXCELSQL;closehd.datedoc, closehd.docno, closehd.BOOKDOCNO, datecancel , closehd.aid, bookhd.saccid ,
EXCELSQL;bookhd.accid, armst.XCOMP,remarkmst.REMARK
EXCELSQL;from closehd left join bookhd on closehd.BOOKDOCNO = bookhd.DOCNO
EXCELSQL;left join armst on bookhd.ACCID = armst.ACCID
EXCELSQL;left join remarkmst on closehd.REMID = remarkmst.REMID
EXCELSQL;order by datedoc,docno
USECROSSTAB;N
CROSSTABFRF;N
CROSSTABHEAD;
CROSSTABFIELD;
