okonkwo
Posts: 3
|
| Posted: 02/06/2018, 5:17 AM |
|
Function DailyTrans_Detail_Bal_BeforeShow(Sender) 'DailyTrans_Detail_Bal_BeforeShow @40-CD057C09
'Custom Code @44-73254650
' -------------------------
SELECT tsd, trans_Date, dailytrans.Income.Value, dailytrans.expenses.Value,
SUM(dailytrans.Income.Value - dailytrans.expenses.Value) OVER(ORDER BY tsd
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
AS dailytrans.bal.Value
FROM dailytrans
' -------------------------
'End Custom Code
|
 |
|
Oper
Posts: 1195
|
| Posted: 03/28/2018, 4:50 AM |
|
you can not do that. That is a SQL sentence
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
|
