How to do a "Totals" Text box?

[Frankythekid]

Hello and Happy New year;

I have a form witha subform in it. The subform has a calculated Text box for a total price ( [Quantity]*[Price per Unit]). But what I want is a new text box in the main form that displays the total sum of all the Totals from the subform.

how is this possible?

This may seem very simple, but a I'm a new user of Access 2000.

Thanks in advance
PS: Can any one recommend me a book, so I can learn to program in Access 2000, VBA codes?

 

[trucktime]

Totals

You can put a box for the Totals in the footer of the subform and then refer to it in a box on the main form.
In the Control Source of the box on the main form it should look something like this:

=SubformName.Form!NameofBoxonSubform

As for learning Access, there are many interesting sites (such as this one) that have lots of useful information and downloadable samples.
I learned a lot just by going through this forum. Can't reccommend any books, hardly use them myself.
If you're interested I'll send you a list of sites.

Good Luck

 

[Frankythekid]

Does that equation sums all of the totals in the subform. Because i have multiple lines in that subform that have total. One for each article bought.

And yes send me those links.

Thanks in advance

 

[trucktime]

Total

You're welcome.

You need a box in the subform for all the totals.

I'll send you a Private Message with the links.

 

[Frankythekid]

How do I sum all of the totals in the subform?

Thanks again.

 

[trucktime]

Totals

Can you upload the MDB (without sensitive data), so I can have a look at it?
That will make things easier.
You can ZIP it and it has to be under 100K in size.

 

[trucktime]

List

Here is the list.
I'm sure there are more useful sources out there.
Just do a search on Google or something.

I just started making a database to store info about Access.
When I see interesting information or some useful code that I may need later I paste it into my mdb.
It has a powerful search function, so anytime I need something it will be at my fingertips.
Especially handy when I can't connect to the Internet.
I'm pretty new to Access myself, just by reading a lot, trial and error I learn.

If anyone has some other good links I like to know, thanks!

 

[Frankythekid]

I'm sorry Trucktime the file has it has been Zipped, it contains 3Mb. It is to big.

What I want to Know, is there a expression where I can add those totals like a Series symbol (Σ) where it adds the same field over and over again.

IE:
In the subform is this:

item Qty Description Price per unit Total
1 3 glue $2.00 $6.00
2 4 scissors $2.50 $10.00

* It was supposed to be each article under each heading
(1 for item, 3 for qty, glue for description, $2.00 price per unit and $6.00 for total) I don't know why it wont appear under each heading?

I want to know how to make a textbox in the Mainform where it shows the total of $16.00 (6.00 + 10.00)

Thanks in advance again:

 

[trucktime]

Total

In the footer of the subform you can put a box, name it: TotalAmount, and set the Control Source to:

=Sum([Total]) (Assuming the field you want to sum is named 'Total')

Then put a Box on the Main Form, set the Control Source to:

=SubformName.Form!TotalAmount

(Don't forget to replace 'SubformName' with the actual name.

Hope this helps.

 

[Janjang]

In the footer of the subform you can put a box, name it: TotalAmount, and set the Control Source to:

=Sum([Total]) (Assuming the field you want to sum is named 'Total')

It Works !!

Then put a Box on the Main Form, set the Control Source to:

=SubformName.Form!TotalAmount

(Don't forget to replace 'SubformName' with the actual name.

Hope this helps.

Not Works..

How bout if i plus 2 Total Amount atthe box at Main Form?
thanks...