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)
Is Not working i Need ur Advice how To Resolve This kindly help me out or resolved it and send it to me
File Link Attached
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.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)