Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Link total balance from form go to report (https://www.askmehelpdesk.com/showthread.php?t=682486)

  • Jul 13, 2012, 07:58 PM
    cicak
    Link total balance from form go to report
    How to add total balance from form to the report. or I can link the total balance to report.. please help me.. this work I should finish this Monday.
  • Jul 13, 2012, 08:00 PM
    cicak
    Quote:

    Originally Posted by cicak View Post
    how to add total balance from form to the report.? or i can link the total balance to report..please help me..this work i should finish this monday.

    Help me please
  • Jul 13, 2012, 09:42 PM
    ScottGem
    You need to give me more details about the structure of your database for me to help.

    Balance is a calculation by adding incoming amounts and subtracting outgoing amounts.
  • Jul 15, 2012, 06:48 PM
    cicak
    When I use this formula my quantity balance is like this.. so many this out.

    (date2/07/12)(in100)(out50)
    (date5/07/12)(in50)(out20) I use this formula sum(nz([quantity in])-nz([quantity out]))
    The ask like this in quantity balance field
    80
    80
    80
    80
    And so on...
    I can hide the collumn q.balance but if I want to do report the quantity balance not appear because the report I use table. You kow what I mean?
  • Jul 16, 2012, 03:39 AM
    ScottGem
    The expression you are using is OK (based on the little info you have given me). But you need to do the same total in your report.

    Again, without knowing the structure of your tables, its hard to advise.
  • Jul 16, 2012, 05:21 PM
    cicak
    Quote:

    Originally Posted by ScottGem View Post
    The expression you are using is OK (based on the little info you have given me). But you need to do the same total in your report.

    Again, without knowing the structure of your tables, its hard to advise.

    I'm sory.. because my english not really OK , so very hard for me to say with you... can I attach my work to you.. where can I send the file?

    And thank for reply my question..

    Can you give me your email? I want to attach my work to u.. easy for you to understand.
  • Jul 16, 2012, 07:14 PM
    ScottGem
    Quote:

    Originally Posted by cicak View Post
    i'm sory..cuz my english not really ok , so very hard for me to say with you...can i attach my work to you..where can i send the file?

    and thank for reply my question..

    can u give me ur email??i want to attach my work to u..easy for u to understand.

    You can zip it and attach it to a post here.
  • Jul 16, 2012, 07:31 PM
    cicak
    Quote:

    Originally Posted by ScottGem View Post
    You can zip it and attach it to a post here.

    Can't attach.. I give u a pic.. wait
  • Jul 16, 2012, 07:42 PM
    cicak
    1 Attachment(s)
    Attachment 40713
    Quote:

    Originally Posted by cicak View Post
    can't attach..i give u a pic ..wait

  • Jul 16, 2012, 07:46 PM
    cicak
    Then how can I do my report
  • Jul 17, 2012, 03:10 AM
    ScottGem
    Your report should be based on a query. Use the SAME expression in your query to calculate total balance. Or use the SAME expression as the control source of a control on your report to display total balance.
  • Jul 17, 2012, 05:15 PM
    cicak
    where u want me to write the expression in report?
  • Jul 17, 2012, 05:30 PM
    ScottGem
    Wherever you want it to appear. It would be as the Controlsource of a control on the report.
  • Jul 17, 2012, 05:36 PM
    cicak
    I mean I should open the property or what?
  • Jul 17, 2012, 05:51 PM
    cicak
    Mr.scott please help me.. I do want u want me to do.. but the result is #error
  • Jul 17, 2012, 06:48 PM
    ScottGem
    What EXACTLY did you do? I can't see what you did.
  • Jul 17, 2012, 06:57 PM
    cicak
    Quote:

    Originally Posted by ScottGem View Post
    What EXACTLY did you do? I can't see what you did.

    I write the SAME expression at my query.

  • All times are GMT -7. The time now is 04:54 AM.