Search results

  1. M

    Solved Accounting Income Statement Query

    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...
  2. M

    Solved Accounting Income Statement Query

    hi dears i would like to thank all of you for your help it is more than appreciated finally i get to a point which i think it is very good attached my final incomestatement report view but i need extra help as attached in image
  3. M

    Solved Accounting Income Statement Query

    hi arnelgp your work is great it gets to the point but really i donot understand your code would you explain your code and how you do how your code affect the queries Public Function mySplit(ByVal sText As String, ByVal pos As Integer, Optional ByVal delim As String = " ") mySplit = ""...
  4. M

    Solved Accounting Income Statement Query

    i am sorry i respect all i just want to get into the point to learn from many perspectives there is many ways to do the job but reach the perfect and easy way is not that easy so we have to be effective and effecient you put your way and explain how you do it to reach the best way to get...
  5. M

    Solved Accounting Income Statement Query

    nice to meet you
  6. M

    Solved Accounting Income Statement Query

    Perfect i like this
  7. M

    Solved Accounting Income Statement Query

    data struture is clear at end of my question if you donot have an answer please take a seat and wait for the answer
  8. M

    Solved Accounting Income Statement Query

    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...
  9. M

    Solved Accounting Trial Balance Query (report)

    from post owner to all happy to see the replies i want to say that Quickbooks is ok no proplem but may be some day come with new technologies and Applications will showup and it will be more effective and effecient than quickbooks every thing has an end there is always new beginnings...
  10. M

    Solved Accounting Trial Balance Query (report)

    thanks you are the best like what you do
  11. M

    Solved Accounting Trial Balance Query (report)

    i will give example if i have HSBC BANK ACCOUNT on -01-01-2019 deposit 300,000 DEBIT on -30-06-2019 withdrawal 50,000 CREDIT ______________END 2019 on -01-01-2020 Deposit 200,000 DEBIT on -30-06-2020 withdrawal 100,000 CREDIT on -31-12-2020 Deposit 500,000...
  12. M

    Solved Accounting Trial Balance Query (report)

    Query contain (1-openingDebit or 2-openingCredit) - (3-Debit and 4-Credit ) (5-endbalanceDebit and 6-endbalanceCredit) First 1 and 2 columns are opening Balance (Debit or credit) Second 3 and 4 columns are Transactions (Sum debit and sumcredit) with in period Third 5 and...
Back
Top Bottom