报告中的期初余额，www.muhammad.aamir.net.tc，下载中的JounalVoucher.mdb. [英] Opening Balance in Report , www.muhammad.aamir.net.tc , in Download u got JounalVoucher.mdb

问题描述

如果您不明白我在说什么，请下载并解决.
在报告中，我的期初余额有问题

查询是...

If you don''t understand what I say, please download and resolve.
In Report, I have issue with Opening Balance

Query is...

SELECT [5 VoucherDetail].vDate, [4 sub].sub_description, [5 VoucherDetail].Txtnarration, [5 VoucherDetail].Debit, [5 VoucherDetail].Credit, [debit]-[credit] AS Balance, [4 sub].s_code
FROM [4 sub] INNER JOIN [5 VoucherDetail] ON [4 sub].s_code = [5 VoucherDetail].s_code
WHERE ((([5 VoucherDetail].vDate) Between [forms]![frmLedger]![stdate] And [forms]![frmLedger]![enddate]) AND (([4 sub].s_code)=[forms]![frmLedger]![AccId]));

请解决此问题，

这是要下载的文件链接
http://www.4shared.com/document/khZrBg5E/aamir_JV.html [ ^ ]

或
https://sites.google.com/site/ksenow/research-reports/JournalVoucher.mdb?attredirects = 0 [ ^ ]

或

Kindly resolve this,

Here is File Link To Download
http://www.4shared.com/document/khZrBg5E/aamir_JV.html[^]

or
https://sites.google.com/site/ksenow/research-reports/JournalVoucher.mdb?attredirects=0[^]

or

www.muhammad.aamir.net.tc
in Downloads (Journal Voucher.mdb) u Got That

推荐答案

此处有一些问题.

1)您的余额有误.在报告详细信息中，您只需减去[借方]-[贷方].您需要创建一个运行余额.

calculate-a-running-sum-cumulative-总计 [ ^ ]

在Access 2007中这很容易，只需在报表上放置一个文本框并设置其"RunningSum"属性

2)在期初余额" DSUM中，替换为以下

A few issues here.

1) Your balance is wrong. Within the report details, you''re just subtracting [debit]-[credit]. You need to create a running balance.

calculate-a-running-sum-cumulative-total[^]

That''s easy in Access 2007, just put a text box on the report and set it''s ''RunningSum'' property

2) In the ''Opening Balance'' DSUM, replace with the following

=DSum("[debit]-(credit)","5 VoucherDetail","[vnum] = " & [Forms]![frmLedger]![Accid] & " AND [vDate] <= #" & [Forms]![frmLedger]![stdate] & "#")

您是否正在寻找带保护套的产品

Are you looking for some with case

CASE WHEN "something" THEN [debit]-[credit] END AS Balance, 

MSDN [

MSDN[^]

*thrown a wild guess

这篇关于报告中的期初余额，www.muhammad.aamir.net.tc，下载中的JounalVoucher.mdb.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！