如何在ADP中調(diào)用在ACCESS寫好的自定義函數(shù)
因原有的資料現(xiàn)在放在了SQL SERVER上,現(xiàn)在ACCESS中想調(diào)用上面的資料進(jìn)行利用,該怎么樣進(jìn)行操作,請各位大俠指點一點,不勝感激!
在ACCESS的查詢里我是這樣寫的
SELECT 財務(wù)明細(xì)帳.錄入日期, 財務(wù)明細(xì)帳.客戶名稱, Qcye([客戶名稱],[錄入日期]) AS 月初余額, Sum(財務(wù)明細(xì)帳.出貨金額) AS 出貨, Sum(財務(wù)明細(xì)帳.回款金額) AS 回款, Sum(財務(wù)明細(xì)帳.折讓金額) AS 折讓, Format(DSum("[期初余額]+[出貨金額]-[回款金額]-[折讓金額]","財務(wù)明細(xì)帳","錄入日期<='" & [錄入日期] & "' and 客戶名稱='" & [客戶名稱] & "' "),"Standard") AS 月末余額
FROM 財務(wù)明細(xì)帳
GROUP BY 財務(wù)明細(xì)帳.錄入日期, 財務(wù)明細(xì)帳.客戶名稱
HAVING (((財務(wù)明細(xì)帳.錄入日期) Between [forms]![發(fā)生明細(xì)表窗口]![開始日期] And [forms]![發(fā)生明細(xì)表窗口]![結(jié)束日期]) AND ((財務(wù)明細(xì)帳.客戶名稱)=[forms]![發(fā)生明細(xì)表窗口]![客戶名稱]))
ORDER BY 財務(wù)明細(xì)帳.錄入日期;
現(xiàn)在在SQL的視圖里要怎么寫才能得出象ACCESS查詢一樣的運行結(jié)果。
望各位大俠能在百忙中能給予詳細(xì)解答。謝謝
(Qcye()為自定義函數(shù))
wuheng 敬上
[此貼子已經(jīng)被作者于2007-4-25 17:25:07編輯過]
|