How to calculate or create subtotal of the data within the subform

[swordspider]

Andd other I need to know is if there are specific data inside the subform how I create a subtotal or a total of input parts and pullout parts. Example if they search a parts how many pullout and how many are available. How I will create a subtotal or total of parts on hand and parts pull-out.

Thank you for your help.

[NeoPa]

Aggregating functions such as Sum() & Count() are available to formulae that can be used in Controls on Forms. I forget whether it's the Fields or the Controls that must be referenced but one is likely to work and the other not.

NB. This is a situation where the default behaviour of naming the Controls with the same name as the Fields can cause you issues. As always, the advice is not to use this default and give them a meaningful name that includes a short code (usually 3 letter) as prefix to indicate the type of the Control.

Fields are where data is stored within a table. Controls are where data is shown on a Form or Report. Though they often show data from Fields they are NOT Fields. They are Controls. Controls may be Bound, where the Control shows data directly from a Field, or Unbound where they don't, but can show the results of a formula if required, or simply allow data to be typed into the Form itself.

Data is shown on a Form (or Report). Forms & Reports neither store nor contain data. No more than queries do.

[swordspider]

Hi NoePa sorry for late reply I'm online only during evening after work. I use the subtraction. This is what I did in my database. I create a table then one of the fields is quantity. I created the main form that I called mpis and the table is called table:mpis. Now I have another table and also I created the table with mostly of the field name is the same of the main table. Because this table is the Pullout where my user when they pullout the parts they will click the pullout button that all the pullout parts will go in this table using the form I created. Now this form I name it Epopi that have also a field called EPOPI. So this form that have name EPOPI and have a table that have a field called quantity will subtract to the table fieild called quantity. I tried what you stated above but sadly the error on the text box I use where I put the expression formula is name or ERRor. And I forgot I use the subform on the mainform. I tried the table as my data source and also the table query. And I hope you will help me with this db problem.

[swordspider]

Sorry I'm wrong the EPOPI that have a field name also called quatity.

[NeoPa]

I thought I had helped you :-s What is it about what I posted earlier that you're struggling with. I can't help unless I know what you've done with what's already there and I don't understand, from what you've said, anything that relates to my post at all.