Ask Experts Questions for FREE Help !
Ask
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #1

    Jul 13, 2012, 07:58 PM
    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.
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #2

    Jul 13, 2012, 08:00 PM
    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
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Jul 13, 2012, 09:42 PM
    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.
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #4

    Jul 15, 2012, 06:48 PM
    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?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #5

    Jul 16, 2012, 03:39 AM
    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.
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #6

    Jul 16, 2012, 05:21 PM
    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.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #7

    Jul 16, 2012, 07:14 PM
    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.
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #8

    Jul 16, 2012, 07:31 PM
    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
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #9

    Jul 16, 2012, 07:42 PM
    Name: access.jpg Views: 113 Size: 89.7 KB
    Quote Originally Posted by cicak View Post
    can't attach..i give u a pic ..wait
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #10

    Jul 16, 2012, 07:46 PM
    Then how can I do my report
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #11

    Jul 17, 2012, 03:10 AM
    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.
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #12

    Jul 17, 2012, 05:15 PM
    where u want me to write the expression in report?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #13

    Jul 17, 2012, 05:30 PM
    Wherever you want it to appear. It would be as the Controlsource of a control on the report.
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #14

    Jul 17, 2012, 05:36 PM
    I mean I should open the property or what?
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #15

    Jul 17, 2012, 05:51 PM
    Mr.scott please help me.. I do want u want me to do.. but the result is #error
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #16

    Jul 17, 2012, 06:48 PM
    What EXACTLY did you do? I can't see what you did.
    cicak's Avatar
    cicak Posts: 11, Reputation: 1
    New Member
    		  
    #17

    Jul 17, 2012, 06:57 PM
    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

I received a 1099A form, but not a 1099C form, do I need to report this? [ 1 Answers ]

I received a 1099A form, but not a 1099C form, do I need to report this?

A trial balance taken at year-end showed total credits exceed total debits by $4,950. [ 1 Answers ]

Failure to report auto and false report form to probation officer [ 3 Answers ]

I know now what my probation officer is charging me with failure to report a truck that was purchased for me and saying a false report forms and failure to report What can happen to me

Form 1099 received, but do I report on Form 1040 or just Form 2106? [ 1 Answers ]

Greetings. I'm hoping I can get some help on what to do with a 1099-MISC form I received from my employer that were for business expense reimbursements. I have read through some questions and answers already and based on them I'm going to file this as a Form 2106. The question is should I...

View more questions Search