Solved Accounting Income Statement Query (1 Viewer)

[mhakim]

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

 

[arnelgp]

i use Dlookup instead.

 

[mhakim]

i use Dlookup instead.

thanks
it is perfect
Appreciated

 

[Pat Hartman]

Really arne? I know you know better.

 

[ahmedjamalaboelez]

Dears
Good Day

are there any recomendation to get a query & Report like this

41100 Sales 5000
51100 Cost of goods sold ( 2000 )
_________________________________________
Gross profit 3000 Calculated
admin General Expenses (500)
other expenses (100)
_______________________________________
Income or loss by Operation (1500) Calculated
______________________________________________________________________________________________________
1- Table Data Transactions like this
Acc accname details debit Credit
____________________________________________________________________
41101 Sales sales invoice 0 1500
41102 sales sales invoice 0 3500
51101 Cost sales invoice 600 0
51102 Cost sales invoice 1400 0
61101 AdminExp salaries 500 0
71101 other other expenses 100 0
____________________________________________________________________
2- Table Chart of Account like this
Acc accname
______________________
41100 sales Total Title Account no Transactions
41101 Sales Transactions Account
41102 sales Transactions Account
51100 Cost Total Title Account no Transactions
51101 Cost Transactions Account
51102 Cost Transactions Account
61100 AdminExp Total Title Account no Transactions
61101 AdminExp Transactions Account
71100 other Total Title Account no Transactions
71101 other Transactions Account
____________________

Use this file , And see video

رابط تحميل برنامج ايزي كونت مديا فير

MediaFire

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

رابط فيديو اليوتيوب ايزي كونت ع اليوتيوب

رابط صفحة الفيس بوك ايزي كونت

برامج المحاسبين Easy Count | Zagazig

‎برامج المحاسبين Easy Count‎, Zagazig. 9,912 likes · 3 talking about this. EasyCount

www.facebook.com