Solved Accounting Income Statement Query (1 Viewer)

mhakim

Member
Local time
Today, 11:15
Joined
Jan 25, 2021
Messages
38
you can use a Query to total those Main accounts.
or you can use DSum() in your report.
see report1.
Dear
i really appreciate your answers i learned alot
thanks

your first example shows data very good in query (data is ready there in quey )
i think we already done calculation (dsum) in Query
we want to recall theses data instead of recalculated again using dsum as you do in you last report

please check you first file attached
Finalquery is there ready with daya
sale 5000
cost 3000

so we want just to recall theses data to cells in report
 

Attachments

  • accounts.accdb
    576 KB · Views: 58

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:15
Joined
May 7, 2009
Messages
16,804
i use Dlookup instead.
 

Attachments

  • accounts.accdb
    528 KB · Views: 75

Users who are viewing this thread

Top Bottom