| [hide] [b][size=2][color=#0000ff]這是反映某個(gè)時(shí)間點(diǎn)的SQL語(yǔ)句如下：[/color][/size][/b] [b][size=2][color=#0000ff] TRANSFORM Sum(客戶資金未到記錄.金額合計(jì)) AS 應(yīng)收貨款 SELECT 客戶資金未到記錄.單位名稱, 客戶資金未到記錄.[收款期限(天)] AS [賬期(天)], Sum(客戶資金未到記錄.金額合計(jì)) AS 應(yīng)收款總計(jì) FROM 客戶資金未到記錄 GROUP BY 客戶資金未到記錄.單位名稱, 客戶資金未到記錄.[收款期限(天)] PIVOT Int(((Now()-[開單日期])/30)+1) & "個(gè)月"; 這是反映某個(gè)時(shí)間段的SQL語(yǔ)句如下： TRANSFORM Sum(客戶資金未到記錄.金額合計(jì)) AS 應(yīng)收貨款 SELECT 客戶資金未到記錄.單位名稱, 客戶資金未到記錄.[收款期限(天)] AS [賬期(天)], Sum(客戶資金未到記錄.金額合計(jì)) AS 應(yīng)收款總計(jì) FROM 客戶資金未到記錄 GROUP BY 客戶資金未到記錄.單位名稱, 客戶資金未到記錄.[收款期限(天)] PIVOT Int(((Now()-[開單日期])/30)) & "-" & Int(((Now()-[開單日期])/30)+1) & "個(gè)月"; [/color][/size][/b]效果如下： [attach]34194[/attach] [/hide]詳細(xì)內(nèi)容：http://m.mzhfr.cn/forum.php?mod=viewthread&tid=67589 |
|站長(zhǎng)郵箱|小黑屋|手機(jī)版|Office中國(guó)/Access中國(guó)
( 粵ICP備10043721號(hào)-1 )
GMT+8, 2025-7-13 08:32 , Processed in 0.076269 second(s), 16 queries .
Powered by Discuz! X3.3
© 2001-2017 Comsenz Inc.
