Search results

  1. S

    The issue with DSUM: not calculating as expected

    can u plz define, what are the steps to use your method.. thanx
  2. S

    The issue with DSUM: not calculating as expected

    hi, by the way, if I want to use this on any report, what are the steps and whats the code and how... plz. Thanx
  3. S

    The issue with DSUM: not calculating as expected

    wonderful arnelgp I have no proper words to thank you. I am grateful . best wishes
  4. S

    The issue with DSUM: not calculating as expected

    nothing helped out yet. problem is still there
  5. S

    The issue with DSUM: not calculating as expected

    check this. a few examples
  6. S

    The issue with DSUM: not calculating as expected

    the problem is that the rest of enteries has false calculations. check that
  7. S

    The issue with DSUM: not calculating as expected

    i have attached the sample DB above. Kindly work it out on Balance as indicated in the above posts. much appreciated...
  8. S

    The issue with DSUM: not calculating as expected

    oh, nothing good came out. the problem of flase calculations is there
  9. S

    The issue with DSUM: not calculating as expected

    nothing has helped nothing has helped yet
  10. S

    The issue with DSUM: not calculating as expected

    Not as expected. The second entry should be 342001 as 400000 has been credited. it gave false results. plz help
  11. S

    The issue with DSUM: not calculating as expected

    Not helped. nothing happened. its the same. anyhow thanx for replying
  12. S

    The issue with DSUM: not calculating as expected

    thanx for helping me out. here is the db attached. goto the form: Customer Orders By Customer Report. then there is only one customer Jerry. put date from 1 jan 2023 to Today. then the report ll populate I am having problem in.
  13. S

    The issue with DSUM: not calculating as expected

    T thanx Doc. Here is the code... FROM [Customer_Orders Query] WHERE ((([Customer_Orders Query].Order_Date) Between [forms]![Customer Orders By Customer Report].[begdate] And [forms]![Customer Orders By Customer Report].[enddate]) AND (([Customer_Orders Query].Customer_ID) Like...
  14. S

    The issue with DSUM: not calculating as expected

    it gave Error in results
  15. S

    The issue with DSUM: not calculating as expected

    hi I have the DSum expression as below: Balance_Customer: Val(DSum("([Amount_Cash_Customer]","Orders","Customer_ID = " & [Customers].[Customer_ID] & " and Order_Date <= #" & [Order_Date] & "#")) but it is not calculating accurateley and there are differences in results, when Order ID in not in...
  16. S

    combobox not working on the form

    hi combobox not working on the form. The attached Db has a form customers. I cant enter anything. Any help plz !
  17. S

    linking table in a query

    thanx
  18. S

    linking table in a query

    Thank You so much Pat Hartman , I have now words to express my feelings, you got time for me . Do I owe you anything? what can I do for you plz.
  19. S

    linking table in a query

    thanx, I ll consider it
Top Bottom