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.

Quote:

---

Originally Posted by cicak

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

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.

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?

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.

Quote:

---

Originally Posted by 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.

---

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.

Quote:

---

Originally Posted by cicak

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.

Quote:

---

Originally Posted by ScottGem

You can zip it and attach it to a post here.

---

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

Attachment 40713

Quote:

---

Originally Posted by cicak

can't attach..i give u a pic ..wait

---

Then how can I do my report

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.

where u want me to write the expression in report?

Wherever you want it to appear. It would be as the Controlsource of a control on the report.

I mean I should open the property or what?

Mr.scott please help me.. I do want u want me to do.. but the result is #error

What EXACTLY did you do? I can't see what you did.

Quote:

---

Originally Posted by ScottGem

What EXACTLY did you do? I can't see what you did.

---

I write the SAME expression at my query.