访问分类帐报表期初余额 [英] Access Ledger Report Opening Balance

问题描述

我制作了会计软件，但在分类帐报表中，我使用Farmula来打开余额或在Farwad中余额，我在下面使用Farmula

I Made Accounting Software but in Ledger Report I Use Farmula for Opening Balance or Balance Farwad I Use Farmula Below

=Nz(DSum("[debit]-[credit]","Ledger_query_backup","[account] = " & [Forms]![Ledger]![Accid] & " AND [Date] = #" & Format([Forms]![Ledger]![stdate],"yyyy-mm-dd") & "#"),0)

无法正常工作，我需要您的建议以解决此问题，请帮我解决或解决该问题并将其发送给我

谢谢你
穆罕默德·阿米尔
附加的文件链接
https://sites.google.com/site/darfun835/download/my.accdb?attredirects = 0& d = 1 [ ^ ]

Is Not working i Need ur Advice how To Resolve This kindly help me out or resolved it and send it to me

Thanking you
muhammad aamir
File Link Attached
https://sites.google.com/site/darfun835/download/my.accdb?attredirects=0&d=1[^]

推荐答案

原因可能是[Forms]![Ledger]![Accid]的值是text 类型必须包含在'' ''中.因此，替换

" & [Forms]![Ledger]![Accid] & "与

''" & [Forms]![Ledger]![Accid] & "''
我认为这可能有效.

The reason may be that the value of [Forms]![Ledger]![Accid] being a text type has to be enclosed within '' ''. So replace

" & [Forms]![Ledger]![Accid] & " with

''" & [Forms]![Ledger]![Accid] & "''
I think it may work.

这篇关于访问分类帐报表期初余额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！