PDA

View Full Version : Link total balance from form go to report


cicak
Jul 13, 2012, 07:58 PM
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
Jul 13, 2012, 08:00 PM
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
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
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
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
Jul 16, 2012, 05:21 PM
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
Jul 16, 2012, 07:14 PM
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
Jul 16, 2012, 07:31 PM
You can zip it and attach it to a post here.

Can't attach.. I give u a pic.. wait

cicak
Jul 16, 2012, 07:42 PM
40713
can't attach..i give u a pic ..wait

cicak
Jul 16, 2012, 07:46 PM
Then how can I do my report

ScottGem
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
Jul 17, 2012, 05:15 PM
where u want me to write the expression in report?

ScottGem
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
Jul 17, 2012, 05:36 PM
I mean I should open the property or what?

cicak
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
Jul 17, 2012, 06:48 PM
What EXACTLY did you do? I can't see what you did.

cicak
Jul 17, 2012, 06:57 PM
What EXACTLY did you do? I can't see what you did.

I write the SAME expression at my query.